Importing Data from a Microsoft Access File on a Mac

Question

Hey guys,

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

Thanks.

Answer 1

Is your Access MDB on mac?

Does the mac Access have the option of using linked tables?
If so, you can create a Linked Table from Access MDB to mySQL. Then, you could treat mysql tables as if it were part of MS-Access.

EDIT: See if this helps.

Answer 2

Have a look at Jackcess. Note that this doesn't support Access 97 databases, however, only 2000+.

For Access 97, the only thing I'm aware of is mdbtools, but that's a C library, so you'll have to write some JNI glue code if you want to use it from Java; also, it's not maintained anymore, to the best of my knowledge.