CODEWITHSUNDEEP
macosms-accessjdbc
shipmaster
shipmaster

Reputation: 3974

Importing Data from a Microsoft Access File on a Mac

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.

Upvotes: 4

Views: 3532

Answers (5)

Gord Thompson
Gord Thompson

Reputation: 123689

UCanAccess is a pure-Java JDBC driver that can read from and write to Access 2000 and newer databases. (Access 97 files are supported read-only.) It will work on any machine that runs Java.

For more details see

Manipulating an Access database from Java without ODBC

Upvotes: 1

Dilip Rajkumar
Dilip Rajkumar

Reputation: 7074

I do the following way to convert;

  1. Download ACCDB MDB Explorer http://accdb-mdb-explorer.en.softonic.com/mac
  2. Open the MDB file
  3. Export as SQL
  4. Import in MySQL using MySQL Workbench.

Hope it helps..

Upvotes: 0

carlhenderson
carlhenderson

Reputation: 3

You could export the MDB file using something like this. This won't help you if you need to do it from within your app, but if you are ok exporting the data then using it, then this should help.

Upvotes: 0

shahkalpesh
shahkalpesh

Reputation: 33474

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.

Upvotes: 0

Pavel Minaev
Pavel Minaev

Reputation: 101595

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.

Upvotes: 5

Related Questions