Opening *.mdb files without MS Access installedPosted: April 6, 2011
Option 1. OpenOffice
- Start OpenOffice “base” component.
- Select “Connect to an existing database”
- Select either Access (in top of the list) or Access 2007 (bottom of the list) database type
- Follow instructions (tick “edit after save”)
You will be able to access data tables (nothing else)
Note: It works on Windows, but I did not succeed in Linux – neither OpenOffice nor LibreOffice seem to have the option for connecting to Access databases. Am I missing something?
Option 2. mdbtools-gmbd
In Ubuntu it is available under Office menu as MDB Viewer, after you install it as mdbtools-gmbd.
Pretty simple tool, but it lets you to see data in your tables and export it to a text file.
By the way, you can download the classic Northwind Traders Sample Database from Microsoft website.