Microsoft.ACE.OLEDB.12.0 Error on 64bit machine

Apr 21, 2010 at 2:16 PM

I got the following error while running the tool on a 64bit machine:

Retrieving BAM Definition from the Excel Spreadsheet... ERROR:The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

To resolve this, i had to download the source code and compile it in x86 mode. Hope this would help others facing the same problem.

Apr 21, 2010 at 2:58 PM

Thanks for the post.  The Data Connectivity Components for Excel (which includes Access runtime in the same redistributable) for Office 2010 finally includes both 32-bit and 64-bit components.  That version should be available soon and will work with Excel 2007 and older files.  I'll probably update the code to look for the 2010 version once the RTM redistributable is available.


Nov 18, 2014 at 12:54 PM
I hit this problem today on a new laptop. I tried downloading the Microsoft data access libraries but that didn't help. I was able to work-around the problem by simply downloading the source code then re-building 32bit for x86 processor. Hope this helps somebody in future.