Importing Data from a Microsoft Access File on a Mac

Question

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.

score 5 · Accepted Answer · answered Sep 01 '09 at 17:53

5

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.

answered Sep 01 '09 at 17:53

Pavel Minaev

94,882
25
209
280

Jackcess supports Access 97 files for reading, but not for writing. – Gord Thompson Nov 11 '15 at 02:24

score 1 · Answer 2 · edited May 23 '17 at 12:29

1

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

edited May 23 '17 at 12:29

Community

1
1

answered Nov 11 '15 at 02:34

Gord Thompson

98,607
26
164
342

score 0 · Answer 3 · edited Oct 20 '12 at 01:57

0

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.

edited Oct 20 '12 at 01:57

McGarnagle

96,448
30
213
255

answered May 01 '12 at 11:47

carlhenderson

3
1
2

shahkalpesh · Answer 4 · 2009-09-01T18:11:49.977

0

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.

edited Sep 01 '09 at 18:11

answered Sep 01 '09 at 17:32

shahkalpesh

31,976
2
61
84

I only have the mdb file, I don't have Microsoft Access Application. What I want is the other way round, importing from that file into my mysql database. I dont want to have to buy Microsoft Access to do that. – shipmaster Sep 01 '09 at 17:39
You don’t need to install ms-access on a win computer to pull data out. You can even use windows scripting to pull data out as text. All recent versions of windows (even going back to win 2000) have the ability to pull data out of an mdb file without having to install ms-access. So no additional software need be installed on a windows box to pull out data from a mdb table. Your problem here is not purchasing ms-access. Purchasing ms-access will not help you unless you have a place to install ms-access (which as I mentioned you don’t need anyway). Do you have boot camp? – Albert D. Kallal Sep 01 '09 at 20:01
Hmm, I don't have a windows license and I don't want to buy one. Neither do I want to buy Office for Mac. Even if I run boot camp, I still need a windows license. My problem is solved however by Jackcess as suggested above, thanks everyone for the replies. – shipmaster Sep 01 '09 at 20:58
1

Access does not and has never run on Macs. – David-W-Fenton Sep 02 '09 at 02:37

score 0 · Answer 5 · answered Nov 10 '15 at 19:10

0

I do the following way to convert;

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

Hope it helps..

answered Nov 10 '15 at 19:10

Dilip Rajkumar

6,832
6
58
74

Importing Data from a Microsoft Access File on a Mac

5 Answers5