[Solved] Microsoft Access > MySQL

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Subfusion
Forum Newbie
Posts: 18
Joined: Mon Aug 15, 2005 6:53 am
Location: Spain

[Solved] Microsoft Access > MySQL

Post 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
Last edited by Subfusion on Fri Aug 19, 2005 6:20 am, edited 1 time in total.
Subfusion
Forum Newbie
Posts: 18
Joined: Mon Aug 15, 2005 6:53 am
Location: Spain

Post by Subfusion »

I found the following tutorial doing a search on google:

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