How to convert access Database to MySQL 5.0

Asked By Jofrey S 0 points N/A Posted on - 08/23/2011

I am using Access 2007 and MySQL 5.0, i have multiple databases in Ms Access which i want to convert to MySQL 5.0, is there  any automatic method or any built in method in both Ms access and MySQL 5.0 like export database to MySQL or import database from access.

Need help urgently. Thanks in Advance.

• Status: Open
• Question Views: 1358
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Database

Best Answer by Daman Mehta

Go To Solution

Answered By Cristo 0 points N/A #117889

How to convert access Database to MySQL 5.0

• Yes, it is possible to download any database into MySQL if you have the MySQL GUI tools. You may download the GUI tools from the below link
• https://dev.mysql.com/downloads/workbench/
• Select the version of the GUI tool as per your OS version. But the only problem in using GUI tool for migration is that it does not work with XAMPP distribution of Apache. Otherwise you can give a try. 
• Other than this you will need to have a DB converter tool for migration of Databases. There are quite a few free downloads available for the conversion tools. But I believe they will be demo software which allows you to convert databases few times and then prompt you to buy the full version.

About Cristo

Questions
0

Answers
6

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/23/2011
• Question Category: Database

Best Answer

Best Answer

Answered By Daman Mehta 0 points N/A #117891

How to convert access Database to MySQL 5.0

• Organize and clean your Microsoft Access database before converting to MySQL This can't be stressed enough and it's pretty much the sole reason your conversion from Access to MySQL will fail or succeed. Think of upgrading from Access to MySQL like a complicated high-wire act. If one person has trouble going across that wire, chances are making him ride a bicycle across it while balancing a ball on his nose will only end up in disaster … and a broken bicycle. Re-design your Microsoft Access database if you have to, but be absolutely sure that your database is designed flawlessly.

• Set up your MySQL database. Just as making sure your Access database is designed flawlessly, your MySQL database must be designed just as flawlessly. MySQL has different data types than Microsoft Access does – you won't find memo fields, for instance – so be sure that your existing data will fit into the structure you build for MySQL. Otherwise, all you're going to get is a mess of mismatched data.

• Export your Microsoft Access data to text files. Fortunately, MySQL has a very handy interface called phpMyAdmin. This allows you to interact directly with your tables through a somewhat graphical UI. All you need to have are tables and fields set up that match your data, and you can click, "Import Data from Text File" through phpMyAdmin. Browse to the text file, import it, and congratulations, your data is online!

• And the last option simply download as many software are available on web to convert access data to mysql freely.

About Daman Mehta

Questions
0

Answers
4

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 09/11/2011
• Question Category: Database