kig>C. Use the Microsoft OLE DB Provider for Jet
kig>This example accesses the orders table in the Microsoft Access Northwind database through the Microsoft OLE DB Provider for Jet.



kig>Note This example assumes that Access is installed.


kig>USE pubs
kig>GO
kig>SELECT a.*
kig>FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
kig> 'c:\MSOffice\Access\Samples\northwind.mdb';'admin';'mypwd', Orders)
kig> AS a