Hi, > Hello people ! I was hoping for some wisdom from the good folks on this > list about moving databases from access to MySQL. > > I am aware of the brute force method of exporting in CSV format or tab > delimited formats and using mysqlimport to move the tables. > > 1. I was wondering if there was a way to dump access databases in SQL > queries like the mysqldump utility does ? > > 2. When exporting tab delimited values from access and using mysqlimport > everything works fine except date columns. All the data moves except the > date field which shows up zero's I mysql after I use mysqlimport. Does > anyone have a clue on what might be happening? > > 3. Is there any way other than downloading some shareware third party > programs to transfer my databases from access to MySQL ?
You might want to try Database Workbench - it has a Schema transfer utility and datapump. Check www.upscene.com With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]