OLE DB Provider and openrecordset
With SQL Server 2005 using SSMS, when I run this:
SELECT * FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0; Database = C: \ TestIDs.xls', 'SELECT * FROM [Sheet1 $]')
And get this:
OLE DB provider "Microsoft.Jet.OLEDB.4.0" is not registered.
Does this refer to a server or local machine?
0
source to share