Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered

Overview

When working with an Excel data source, you may encounter error messages that indicate the Microsoft ACE OLE DB provider is not registered.

This error can be presented in many forms.

Examples:

"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine."

error message

"The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000."

"An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered"."

"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. For more information, see http://go.microsoft.com/fwlink/?LinkId=219816. SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER."

"The AcquireConnection method call to the connection manager "Data Source Forecast_Sales" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed."

Resolution Process

Install Microsoft Access Database Engine 2010 Redistributable.  These components can be found here: Microsoft Access Database Engine 2010 Redistributable

Ensure that you explicitly run the executable as an administrator

Published:

Error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered

Overview

When working with an Excel data source, you may encounter error messages that indicate the Microsoft ACE OLE DB provider is not registered.

This error can be presented in many forms.

Examples:

"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine."

error message

"The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. Error code: 0x00000000."

"An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered"."

"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. For more information, see http://go.microsoft.com/fwlink/?LinkId=219816. SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER."

"The AcquireConnection method call to the connection manager "Data Source Forecast_Sales" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed."

Resolution Process

Install Microsoft Access Database Engine 2010 Redistributable.  These components can be found here: Microsoft Access Database Engine 2010 Redistributable

Ensure that you explicitly run the executable as an administrator

For an optimal Community experience, Please view on Desktop