SQL Server 2008 R2 Excel Import
I'm using SS 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.Data)
I am very new to this and would greatly appreciate any help I can get.
Incidently, I also may be doing this wrong (and therfore getting the error) because if I choose the 64 bit import wizard there is no option for Microsoft Excel. So, I am trying to use the 32 bit wizard. Does anyone know how I can get this to work? Thanks in advance!
For other users: For anyone who has this same problem, The answer that a1ex07 suggested works for Office 2010 as well. Check this thread The 'Microsoft.ACE.OLEDB.12.0' provider is not registered in the local machine
Answer
I was having the same problem trying to import an Excel file using SQL Management Studio (SMS 2012). I use 64-bit version of everything including Office 2013. This solution from social.msdn.microsoft.com solved it for me:
The problem you are likely having is the Import/Export Wizard is being launched as the 32-bit version. This is probably due to you right clicking on a database and clicking on import and since SSMS is a 32-bit program it will launch 32-bit processes. Try explicitly running the Import/Export Wizard (64-bit) by clicking on Start->Program Files->Microsoft SQL Server 2012->Import and Export Data (64-bit) to import your data from a 64-bit datasource.
Noral Kuhlmann