Windows 7 (64 bit): “The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered in the local machine”.


When 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.

 

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s