There was an error in this gadget

Wednesday, May 2, 2012

SQLServer 2008 R2--'Microsoft.ACE.OLEDB.12.0' provider is not registered


I'm using SQLServer 2008 R2 and Office 2010 on a Windows 7 64 bit. I am trying to use the import wizard to import an excel sheet into a table. I get this error:
 The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.)

Solution:
Install the Microsoft Access Database Engine update.

http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

No comments:

Post a Comment