Geek Answers Handbook

Import data from a Microsoft Access file on Mac

I have an MS-Access mdb file that I need to import from my mysql instance. I'm on a mac, are there any free / OSS tools that let me do this? If not, is there a free / OSS JDBC driver that I can use to extract the data I need?

Thanks.

+4
source share
5 answers

Take a look at Jackcess . Please note that this does not support Access 97 databases, but only 2000+.

For Access 97, the only thing I know is mdbtools , but it is a C library, so you will have to write some JNI glue code if you want to use it with Java; In addition, it is no longer supported as far as I know.

+5
source

UCanAccess is a pure Java JDBC driver that can read and write to Access 2000 and newer databases. (Access 97 file access is read-only.) It will work on any computer running Java.

See details

Manipulating an Access Database with Java without ODBC

+1
source

Is your MDB for Mac access?

Does Mac Access have the ability to use linked tables?
If so, you can create a linked table from Access MDB to mySQL. Then you can process the mysql tables as if they were part of MS-Access.

EDIT: see this .

0
source

You can export the MDB file using something like this . This will not help you if you need to do this from your application, but if you export data well and then use it, then this should help.

0
source

I am doing the following conversion method:

Hope this helps.

0
source

More articles:


All Articles