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)
转载于:https://www.cnblogs.com/bestsaler/archive/2009/03/20/1835735.html