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"


Hope that helps someone...


No comments:

Post a Comment