Celtic Coding Solutions Blog

Celtic Coding Solutions Blog - for everything computer related

Error when importing Excel 2007 spreadsheet into SQL Server 2012

Tried to import an Excel 2010 spreadsheet (file extension xlsx) into SQL Server 2012 using the import wizard and selecting Microsoft Excel 2007:-

 

Then I had the following error on my Windows 7 x64 PC:-

SQL Server Import and Export Wizard Error

Additional Information: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)

This is strange as I have Office 2010 x64 abortion hotline installed?

Fix: you need to install generic abortion pill the x86 (32bit) Office drivers.  This is a simple download from Microsoft called "2007 Office System Driver: Data Connectivity Components".

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

Comments are closed