• 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!