HOW TO: FIX ERROR – “the ‘microsoft.ace.oledb.12.0’ provider is not registered on the local machine”
Posted: November 26, 2012 Filed under: Excel 2007, Excel 2010, SQL Server Leave a commenthttp://social.msdn.microsoft.com/Forums/en-US/vstsdb/thread/1d5c04c7-157f-4955-a14b-41d912d50a64
Windows 7 (64 bit): “The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered in the local machine”.
Posted: June 6, 2012 Filed under: Excel 2010, SQL Server 2008 Leave a commentWhen I try to import Excel 2010.xlsx file into my local SQL Server R2 database from my Windows 7 machine (64 bit), I ran into this error message: “The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered in the local machine”.
I found a solution from a quick search: to install Microsoft Access Database Engine 2010 Redistributable from this link: http://www.microsoft.com/en-us/download/details.aspx?id=13255
The catch point is to install the 32 bit instead of 64 bit.