Pulling Data From an Access Database

0
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://community.mendix.com/link/questions/8179 Thanks in advance. 
asked
4 answers
6

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.

answered
2

If you end up going the excel sheet route. Check out this article to make it a little less tedious.

 

https://docs.mendix.com/howtogeneral/tips/import-a-large-excel-file

answered
1

As a workaround you could try to transfer all the data from Access to Excel first and then just import the different Excel sheets.

Regards,

Ronald

 

answered
1

Ya. That was my first thought as well. I was hoping that someone may have come up with something less time consuming. haha

answered