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
Fix: you need to install
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