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
For anyone who has this same problem, The answer that a1ex07 suggested works for Office 2010 as well. alex07's answer The 'Microsoft.ACE.OLEDB.12.0' provider is not registered in the local machine ... this answer originally came from kd7.