Database drivers: PostgreSQL | Linux MDB | SQLite
Note: This driver does not reflect the latest development anymore. If you want to test the latest version, then please download the complete OpenOffice.org snapshot containing the latest and greatest driver.
This snapshot has been taken from CWS mdbdriver02, where the actual development takes place.
If you download it, and want to share your feedback (please do so!), send a mail to email@example.com. Thanks.
Use MDB Tools to read Microsoft Access files under linux.
download mdbtools 0.5.0 source tarball from mdbtools.sourceforge.net.
Install a OpenOffice.org1.1 or newer if you have not done so already.
Download the binary version of the driver.
Copy the zip file in
OpenOffice1.1/user/uno_packages folder (Note:
USE the zip file as a whole, DO NOT extract it). Open up a shell and switch to
the OpenOffice1.1/program directory and start the pkgchk tool. On success, no
output is given. Alternatively, you can install the driver for all users of a
OpenOffice.org network installation by placing the file into the
and starting pkgchk --shared You can uninstall the package by deleting the file
in the uno_packages directory and starting pkgchk again.
Adding a datasource
You can now add a datasource via the common Tools/Data Sources dialog. Click on new datasource and select mdb from the Database type combobox. You should currently put the file name of your mdb file into url line.
It is a readonly driver,you can't use to to write data into a mdb file.
It only supports a small set of sql language. Such as
select * from table_name
select col1 from table_name where col1 = 1
select ¡°col1¡± from table_name where col1 = 1 and col2 < 10
The driver has been implemented and is maintained by Wind Li (firstname.lastname@example.org).