EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'D:/car.mdb';'admin';'',pcar)
GO
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'D:/car.mdb';'admin';'',pcar)
GO