Microsoft.ACE.OLEDB.12.0 is not registered.
Applies to: SQL Server 2012, SQL Server 2014.
Problem Description.
When you try to run a SSIS package that uses a Excel 2013 file as data
source, you may get the following error:
“The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If
the 32-bit driver is not installed, run the package in 64-bit mode.”
Additionally, if you try to use SQL Server Management Studio Import Export
Wizard, you may get then the following error message:
"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine"
Solution.
Let's try the following solutions:
- Install the “2007 Office System Driver: data connectivity components”
from
here. That alone should solve the issue.
- If the operating system is 64-bit, download "Microsoft Access Database
Engine 2010 Redistributable" 64-bit and 32-bit from
here and install them
both.
- If the operating system is 32-bit, download "Microsoft Access Database
Engine 2010 Redistributable" 32-bit from
here.