I am trying to import some Microsoft Access tables from a .accdb file, but I get the above error message. I have tried installing the Microsoft Access database engine 2010 and the Microsoft Access database engine 2007, but no joy. I keep getting the above error message.
If I set up an ODBC DSN and try using that I get "ERROR [IM014]] [ ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
How do I import Access tables, please?
Cannot find OLE DB providers: Microsoft.ACE.OLEDB.12.0
-
- Posts: 8
- Joined: Wed 27 May 2015 12:34
Re: Cannot find OLE DB providers: Microsoft.ACE.OLEDB.12.0
In case you are running dbForge Studio for MySQL on a 64-bit Windows operating system, you need to install a 64-bit version of Access Database Engine rather than a 32-bit version http://www.microsoft.com/en-us/download ... x?id=13255
Also, you can vote for the following suggestion on our UserVoice forum http://devart.uservoice.com/forums/7729 ... ng-systems
Also, you can vote for the following suggestion on our UserVoice forum http://devart.uservoice.com/forums/7729 ... ng-systems