I've used the exportSQL script (http://www.rot13.org/~dpavlin/projects/sql/exportSQL3.txt) to dump tables out of Access into a file that can be imported by mySQL. Since a lot of my work is porting Access apps to web apps, it comes in very handy.
I've also written a really simple VB script that copies the records directly from Access to mySQL via ODBC. It uses DoCmd.TransferDatabase, if you'd like to write your own. I'd be happy to share it. -- Brett ----- Original Message ----- From: "Bing Du" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Thursday, July 28, 2005 9:32 AM Subject: migrate Access to MySQL Hello, I've been looking around for a while. Seems there are many options and tools that can help do it. Guidance and directions are highly welcome. We need to move the contents of a bunch of tables from Access to the existing tables on MySQL. The target tables in MySQL already have some information. So we need some how to map Access fields to MySQL fields. Anybody would like to share experience about how you did your migration and what kind of tool can best meet needs as such? Thanks much in advance, Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
