Re: migrate Access to MySQL
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 > 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] > > __ Yahoo! Mail for Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 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 > Thanks all who replied. I had no problem transfering Access tables to MySQL as they are. My problem is we need to munge the data first before they can be loaded into MySQL. I see coding is inevitable. Bing -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: migrate Access to MySQL
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: 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]
Re: migrate Access to MySQL
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]
