We are attempting to pull data from a legacy system that was built within access. We want to be able to pull that data from the access database and leverage it within the Mendix platform. Currently the database connector does not work and we receive the following error: Synchronization for MS Access is not implemented Does anyone have anything they have done previously to pull data from the database or do we need to do an import/export process in order to accomplish this task? Or would the better option be to use the database synch module: https://forum.mendix.com/link/questions/8179 Thanks in advance.
I would suggest converting the Access database to a sql server database. Microsoft offers a pretty straight forward tool to do this. From there you can use the database connector.
If you end up going the excel sheet route. Check out this article to make it a little less tedious.