How to convert access Database to MySQL 5.0

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.