I need to convert an Access 2007 database to MySQL 5.5. The Access database has thirteen tables. My first thought on how to do this is to create the MySQL database and tables by hand and to write a program that connects to both databases, which gets the data from the Access database and inserts it into the MySQL database. Is this the way you folks would go about doing this? Or is there something that I'm missing that can make some or all of the steps that I said easier? Please advise me on how to handle this project.

October 24th, 2012, 05:24 AM

VictorN

Re: To Migrate Access db to MySQL

Well, it the database has only thirteen tables then you can convert it as you want without much problems.