Page 1 of 1

[Solved] Microsoft Access > MySQL

Posted: Fri Aug 19, 2005 5:35 am
by Subfusion
I currently have a MySQL database which is regularly updated online. I also have an access database that has data that I wish to put into the MySQL database but I don't want to type it all out again as it has a lot of records. Both my table structures are the same.

Is there any tool I can use that can transfer my Access data to MySQL (I want the ID field to be blank and I want the script or tool that transfers this to MySQL to generate a new ID). Thanks :)

- Subfusion

Posted: Fri Aug 19, 2005 6:20 am
by Subfusion
I found the following tutorial doing a search on google:

http://www.stardeveloper.com/articles/d ... 901&page=1