PHP programmatic and automated synchronization of ms access with MySQL

At work we have a commercial access control system monitoring wh开发者_如何转开发o enters/exits the building. This system stores a log into a MS Access file on the server where it is installed. The company has not released an API for this system so I cannot get the system to store the data elsewhere.

We have an intranet site built on CakePHP/MySQL. There I want to implement a section that will provide reports to HR using the data from that system. However I'm stuck trying to figure out how to programmatically and automatically import and keep synchronized the data from the MS Access into the MySQL database.

Any help would be appreciated.

Instead of keeping these things in sync, I would simply query the Access database as necessary. I think you will end up with a much more reliable system this way.

Edit: If you really wanted to, there are commercial solutions for this. As long as you only need to go one direction, it should be doable. Again though, not rcommended.