T-SQL: Using OPENROWSET to Join Server Data with File-based Data

USE pubs ;

SELECT Customers.* , Orders.* FROM Northwind.dbo.Customers AS Customers , OPENROWSET( -- OLE DB Provider Name: 'Microsoft.Jet.OLEDB.4.0'

    -- OLE DB Provider Source, ID and Password or Connection String:
,   'C:&bsol;&bsol;Program Files&bsol;&bsol;Access97&bsol;&bsol;Office&bsol;&bsol;Samples&bsol;&bsol;northwind.mdb';'admin';''

    -- OLE DB Provider Object (e.g. table name) or Pass-Through Query:
,   Orders
) AS Orders

WHERE Customers.CustomerID = Orders.CustomerID GO

mod date: 2001-05-27T01:13:57.000Z