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."
"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
These steps should be tried in the following order until the issue is resolved.
-
Make sure the Jet Data Manager and Excel have the same bit-rate. If Excel is 32-bit, you will need to install the 32-bit version of the Jet Data Manager. If Excel is 64-bit, you will need to install the 64-bit version of the Jet Data Manager.
-
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 -
Install 2007 Office System Driver: Data Connectivity Components. These components can be automatically downloaded here: 2007 Office System Driver: Data Connectivity Components
Ensure that you explicitly run the executable as an administrator
Comments