title: What is the best way to synchronize data between MS Access and MySQL?
body: <p>I have an access database on a windows machine, which I must import into mysql on a linux webserver. At the moment the access dabatbase table is exported as a text file, automatically copied with ftp, and then loaded into mysql.</p>
  
  <p>Is there a better way to do this, perhaps using an ODBC connection or something else? </p>
  
  <p>What is the best way to limit copying information that is already present, ie to only transfer records that are in the access database but not yet in the mysql one.</p>
  
  <p>The access database is handled by another program, and it would be best if I did not have to makes changes to it, or even open it. There is no possibility of needing to import updated records from the access database. The mysql database will be the main source, and some records will be deleted or changed. I only want to import records that were never in the mysql database, not restore the ones that were purposefully deleted.</p>