Convert Access DB to MySQL DB, is it possible?

[Mdonahue37]

Does anybody have any suggestions on how to convert an Access (97 I believe) database to a MySQL database? Are there any tools that can actually convert the tables with it's data from one to the other? Or does anybody know of any shortcuts to speed up the migration?

Any help would great, thanks.
Mike D.

[Daemonspyre]

There are a couple of converters out there...

MySQL Migration Toolkit (http://dev.mysql.com/downloads/gui-tools/5.0.html) is one of them. Works quite well.

Another is DBTools Manager Professional (http://www.dbtools.com.br/EN/index.php).

Another thought is that you can export your MSAccess tables to .TXT or .SQL files and import them into MySQL using the LOAD DATA INFILE command.

http://dev.mysql.com/doc/refman/5.0/en/load-data.html

HTH!

[Mdonahue37]

Thank you for responding. I should have mentioned that I'm working on a Mac, so niether of the tools are available to me. Are you aware of an Mac apps that sport the same functionality? Do either of them build the tables and bring in the data in one step? If they did I could get my hands on a PC to do the migration.

Again, thanks.
Mike D.

[Daemonspyre]

Both do what you are looking for as to table definition creation and data migration, however, as I am a waxing Linux/ waning Windows guy, I don't know about those programs for Mac. Try google for that.

I would just use the PC to do the main switchover, then use the MySQL CLI Client or the MySQL GUI client to access the MySQL server.