Re: migrate Access to MySQL

2005-07-31 Thread Karam Chand
http://www.webyog.com/forums/index.php?s=7a01772d367884257ac1c2f12b792027&showtopic=1536&view=getnewpost Karam --- Bing Du <[EMAIL PROTECTED]> 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 > ar

Re: migrate Access to MySQL

2005-07-28 Thread Bing Du
> 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 hav

Re: migrate Access to MySQL

2005-07-28 Thread avrombay
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 cop

Re: migrate Access to MySQL

2005-07-28 Thread Kieran Kelleher
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. Seem