The OLE DB provider Microsoft.ACE.OLEDB.12.0 has not been registered.Here is my environment:
Windows 7 (64-bit)
SQL Server 2008 R2 (64-bit)
MS Access 2010 (64-bit)
MS Office Excel 2010 (64-bit)
I do NOT get the above error when I use the import wizard in MS Access 2010 to import my Excel (.xlsx). It only happens with SSMS. I tried installing the different Data Connectivity Components. Some would say it was already installed, other would complain that it wouldn't work with the 64-bit software I was using. In the end the only one that would install that helped was the following:
2007 Office System Driver: Data Connectivity Components
So frustrating that I had to waste time on something that should just work after installing SQL Server 2008 in my opinion.