Saturday, September 1, 2012

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

I was recently using SSIS (SQL Server Integration Services) in SQL Server 2012 to attempt to import an Excel spreadsheet into a SQL Server database table, when I encountered the following error message:

After doing a bit of further research, I discovered an article which pointed to this download:

So after installing the Microsoft Access Database Engine 2010 Redistributable (I installed the 32-bit version), I was able to successfully import my Excel spreadsheet using SSIS!!

No comments:

Post a Comment