Home > Documentation > MS Access to MySQL

Merging MS Access data into the MySQL database

MS Access to MySQL converter implements quite simple merging algorithm. If both source and destination tables have primary key or an unique index, the program inserts into MySQL database only those records whose key/index value does not exist in the destination table. Otherwise, the application appends contents of the entire MS Access table. If structures of MS Access and MySQL tables distinguish, the program transforms each record of the source table so that it conforms to the destination table structure.

Have more questions? Contact us