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


1 answer


it refers to the server.



0


source







All Articles