Advice on a Free MS Access DB to MySQL Converter

[dainstructor]

I have a couple databases in MS Access that I would like to convert to MySQL. While speaking to a coworker a while back he mentioned having trouble with one of the free download tools that he used.

Does anyone have any advice on any good Converters? Or possibly one I could use a trail version for? I'm not sure if I'll need it again anytime soon, so I'm somewhat hessitant to spend a lot on one.

Thanks in advance,

[henry0]

You could try to save it as a XL or CSV
then go to phpMyAdmin and import from ..file format etc..

[Brad_H]

I like to just setup a ODBC link to the MySQL database, and then just right-click the tables in Access and export to ODBC.

[henry0]

Good to know even if I do not use MS Access :)

[numnutz]

HI - Use mysql connector odbc available here (free download) [mysql.com...]

or write a small php program to dump the database in CSV format
or use phpmyadmin to do the same. This might mean you have to re- reate the database data dictionary by hand

hope this helps

nn :)

[bysonary]

hello

download the mysql GUI tools from mysql website, there is a migration toolkit in there I have only ever migrated a very basic access database using it, however it seemed to work fine plus its free.

Hope that helps