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