insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'C:\db.mdb';'admin';'', Test) select id,names,age from Test
use test
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'C:/db.mdb', Test)
select id,names,age from Test
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'C:\db.mdb';'admin';'', Test)
select id,names,age from Test
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure