Customers may experience issues accessing Flexera One due to AWS Issues. For more information, please click here.

Business Adapter Studio shows "The MicrosoftAce.OLEDB.12.0 provider is not registered on the local machine"

Business Adapter Studio shows "The MicrosoftAce.OLEDB.12.0 provider is not registered on the local machine"

Symptoms:

When importing source data with Microsoft Office format data, the error message below appears:
"The MicrosoftAce.OLEDB.12.0 provider is not registered on the local machine"

Diagnosis:

A prerequisite for the software is missing.

Solution:

Download and install the 32bit version of Microsoft Access Database Engine 2010 Redistributable.

https://www.microsoft.com/en-us/download/details.aspx?id=13255

Was this article helpful? Yes No
No ratings
Comments

That is a very old version of the driver that is likely end of life.

There is a version 2016 version of the driver that also works.  As highlighted in the KB, you must download and install the 32-bit version of the driver.

https://www.microsoft.com/en-us/download/details.aspx?id=54920

Version history
Revision #:
1 of 1
Last update:
‎Jun 19, 2020 03:23 PM
Updated by:
 
Contributors