Make a select query in Access whose result mimics the table layout of the target table in MySQL. Then export the query as tab-delimited text and import into the MySQL table using LOAD DATA INFILE.

On Jul 28, 2005, at 12:32 PM, Bing Du wrote:

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]

Reply via email to