Monday, July 9, 2012

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

Today I got that error message while using the import and Export wizard on windows 7, running SQL Server 2008 R2, 64 Bit.


I was importing from an Excel 2010 sheet.

The solution is to download and install the "2007 Office System Driver: Data Connectivity Components"

From: http://www.microsoft.com/en-us/download/details.aspx?id=23734

Hope that helps someone...