The SQLyog' Data Sync Tool' will sync between 2 MySQL databases. But the 'Import External Data Tool' will import data from any ODBC source including Access. If the ODBC driver can connect over the Internet then also SQLyog can connect to the ODBC source.
The tool will not detect changes on the ODBC source automatically. It is not a 'listening background process'. You can schedule the task to run at intervals. Please check the resources:
* relevant paragraph in the program help file
* this old but still relevant article: http://www.databasejournal.com/features/my…Lyog-ver-41.htm
* this FAQ: http://www.webyog.com/faq/content/17/79/en…-data-tool.html
* and this FAQ: http://www.webyog.com/faq/content/27/114/e…agent_-sja.html
Please download and install the ENTERPRISE TRIAL. Only you can judge if it is relevant for your needs.