Forum Moderators: coopster

Message Too Old, No Replies

Advice on a Free MS Access DB to MySQL Converter

         

dainstructor

3:08 pm on Dec 12, 2006 (gmt 0)

10+ Year Member



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

3:43 pm on Dec 12, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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

Brad_H

4:43 pm on Dec 12, 2006 (gmt 0)

10+ Year Member



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

5:47 pm on Dec 12, 2006 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



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

numnutz

7:27 pm on Dec 12, 2006 (gmt 0)

10+ Year Member



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

2:12 pm on Dec 13, 2006 (gmt 0)

10+ Year Member



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