QUESTION:
I am getting the following error any time I try and load a csv or accdb file:
- The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
How can I resolve?
ANSWER:
The errors occurs when running the 32-bit version of Office 2013 or lower with the 64-bit version of DemandTools. There is NO RESOLUTION if running the 32-bit version of Office 2007 or 2010 with the 64-bit version of DemandTools. To read/load csv and accdb files with those versions of Office, users will need to use the 32-bit version of DemandTools vs. the 64-bit version, or they can upgrade to a 64-bit version of Office (available in Office 2010 or higher).
If running 32-bit Office 2013 the 64-bit Microsoft Access Drivers can be manually installed on the PC. The drivers can be downloaded here.
**********After clicking "Download" select "AccessDatabaseEngine_x64.exe" to install the 64 bit drivers************
Notes:
- The 64 bit drivers CAN ONLY be installed manually when running Office 2013 (not allowed for 2010 or lower)
- Customers who previously needed to manually install 32-bit Microsoft Access Drivers with Version 2.5 will need to FIRST UNINSTALL THE 32-bit Drivers, then install the 64-bit drivers. When the 32-bit drivers are installed the following message will be displayed when attempting to install the 64-bit drivers:
- You cannot install the 64-bit version of Microsoft Access Database Engine 2010 because you currently have 32-bit Office products installed. If you want to install the 64-bit Microsoft Access Database Engine 2010, you will first need to remove the 32-bit installation of Office products.
- BOTH the 64-bit and 32-bit version of DemandTools can be installed on the same PC if needed (since they install in different directories), i.e. use the 32-bit version when needing to read csv or accdb files (assuming an upgrade to 64-bit Office is not feasible for some reason).
