The script to automatically convert a table dump from Microsoft Access to an update / insert query for MySQL is nearly complete for general use. It will be uploaded by tomorrow very soon for use. The script itself takes a text file dump of table data and converts the file into a list of queries to update a matching table in a MySQL database. All you need to do is make sure that the fields in both tables are the same for where you want them to be, they dont even need to be the same column names. Full instructions on exporting the data into a correctly formatted tables.txt file will be included.

 

Once this is complete it will not be long before the same thing is released for MySQL to Access, and soon after the Postgre scripts will follow.If you have any questions or suggestions then please contact me .