exec sp_configure 'show advanced options',1 reconfigure exec sp_configure 'Ad Hoc Distributed Queries',1 reconfigure go
--插入 insert into opendatasource('Microsoft.jet.oledb.4.0','data source=E:\temp\test.mdb;user id=admin;password=;')...[test](name) select 'mxh'
--查询 select * from opendatasource('Microsoft.jet.oledb.4.0','data source=E:\temp\test.mdb;user id=admin;password=;')...[test]
exec sp_configure 'Ad Hoc Distributed Queries',0 reconfigure exec sp_configure 'show advanced options',0 reconfigure go