View Full Version : Migrating an msAccess DB to MySQL

09-22-2006, 02:42 AM

Well, as the subject of this post says, I want to convert a microsoft access database into a MySQL database. I'm already running Ubuntu 6 server with a LAMP installation. The MySQL server is already up and running and I've created some test databases. The Access database is located on a Windows server.
I have full permissions to the Access database and the MySQL database. I'd like the migration to be as simple and painless as possible. Any recommendations on free tools to use?

Thank you for your time,


09-22-2006, 05:28 AM
I posted some links to some great conversion tools in this thread (http://www.codingforums.com/showthread.php?t=76246&highlight=access+mysql). In that thread though, I neglected to mention the one I use - here (http://www.convert-in.com/acc2sql.htm). In my opinion, it's the best. If you're looking for freeware, try one of the links in that thread.