MS Access to MySQL
- Thread starter axis27
- Start date
ElDiabloConCaca
U.S.D.A. Prime
There's not much, if any, software on Mac OS X that will read or write an Access database -- Access is a proprietary format by Microsoft that's been pretty devoid of converters or readers on the Mac side of things.
Best bet would be to temporarily gain access to a PC with Access and export the database into a format better readable on the Mac.
Best bet would be to temporarily gain access to a PC with Access and export the database into a format better readable on the Mac.
HateEternal
Mac Metal Head
The only thing I could find to allow you to read a Access database w/o involving a PC was this ODBC driver. It is supposed to have full SQL query access but no write access. Costs a little bit of cash, but if you absolutely can't use a PC this will help you get your data out, given you know SQL.
Putting the data back into a MySQL database might prove a little more tricky if you don't know how to program, but if you do, I couldn't see it being too complicated of a program. Also, even with 1337 programming skills, copying over the design of the database could prove to be a real PITA. Even if there are ways to query the definition of tables with access you would still have to convert that definition to use MySQL syntax. It probably would be easier to just manually recreate the tables, then programatically copy the data.
... so yea... it's possible, with the right resources. I doubt you will find anything to do exactly what you want though, for the same reasons that ElDiabloConCaca mentioned.
Putting the data back into a MySQL database might prove a little more tricky if you don't know how to program, but if you do, I couldn't see it being too complicated of a program. Also, even with 1337 programming skills, copying over the design of the database could prove to be a real PITA. Even if there are ways to query the definition of tables with access you would still have to convert that definition to use MySQL syntax. It probably would be easier to just manually recreate the tables, then programatically copy the data.
... so yea... it's possible, with the right resources. I doubt you will find anything to do exactly what you want though, for the same reasons that ElDiabloConCaca mentioned.
I've done it successfully on the windows side, I believe that I used this free program:
http://www.fonlow.com/dbconverters/ -- update not that one, sorry can not find it, but this one gets good reviews:
http://www.mysqlfront.de/
Here is the official way using MySQL Migration;
http://dev.mysql.com/doc/migration-toolkit/en/index.html
Maybe you find one time access to a Windows box to do the conversion?
Maybe you find one time access to a Windows box to do the conversion?
http://www.fonlow.com/dbconverters/ -- update not that one, sorry can not find it, but this one gets good reviews:
http://www.mysqlfront.de/
Here is the official way using MySQL Migration;
http://dev.mysql.com/doc/migration-toolkit/en/index.html
Maybe you find one time access to a Windows box to do the conversion?
Maybe you find one time access to a Windows box to do the conversion?
moisheweiss
Registered
I would have access output the database as .csv and then read the .csv program. I saw a free utility to convert .csv to mysql but I don't remember what its called.