I'm in SQL 2008 64bit clustered this is my unhappiness
Error/Information message I receive
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.
Query I'm running
SELECT * FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=C:\SqlServerInstances.xls;Extended Properties=Excel 8.0')...[Customers$]
Am I missing something? Have they renamed the provider to something else, or simply removed it .
End of day so tired come back with a fresh brain tomorrow in the mean time if you got something please share!