This was a useful one to find, awhile back. These days it’s probably easier to just export the data and import it on the other side.
Thanks to this site:
http://www.cynergi.net/prod/exportsql/
Copy into a module in Access, then run. Note that there are some hitches to keys that are made which are not NULL and need to be.
Then run mysql in batch mode with:
mysql -u root -p < script.sql
Danyell | 13-May-03 at 12:46 am | Permalink
I’m not one to plug commercial software, but Origami forked the $55 for a commercial license to Access-to-MySQL, a Windows-based conversion tool. We’ve done some nasty, huge conversions with it and it’s really solid. The bulk conversion is a must-have for site builders. It’s also a great tool for anyone weird enough to actually ENJOY prototyping databases in Access (like yours truly).
The program can do a live conversion directly into a MySQL server or dump to a .sql file ready to pipe to the mysql client/command-line utility. The quality of the SQL is way above average.
There’s also a cheaper ($40) non-Pro version that I’ve never used.
http://www.convert-in.com/acc2sqlp.htm