从sqlserver导入access的最简单的方法

 select * into Expro from openrowset('Microsoft.Jet.OLEDB.4.0','D:\db\db\1.mdb';'admin';'',Content)
insert into  Expro select * from openrowset('Microsoft.Jet.OLEDB.4.0','D:\db\db\2.mdb';'admin';'',Content)
insert into  Expro select * from openrowset('Microsoft.Jet.OLEDB.4.0','D:\db\db\3.mdb';'admin';'',Content)
insert into  Expro select * from openrowset('Microsoft.Jet.OLEDB.4.0','D:\db\db\6.mdb';'admin';'',Content)
insert into  Expro select * from openrowset('Microsoft.Jet.OLEDB.4.0','D:\db\db\7.mdb';'admin';'',Content)
insert into  Expro select * from openrowset('Microsoft.Jet.OLEDB.4.0','D:\db\db\5.mdb';'admin';'',Content)
insert into  Expro select * from openrowset('Microsoft.Jet.OLEDB.4.0','D:\db\db\4.mdb';'admin';'',Content)