/**//*************导出到Access********************/ insert into openrowset('Microsoft.Jet.OLEDB.4.0', 'x:\A.mdb'';''admin'';''',A表) select * from 数据库名..B表/**//*************导入Access********************/ insert into B表 select * from openrowset('Microsoft.Jet.OLEDB.4.0', 'x:\A.mdb'';''admin'';''',A表)参考 http://singlepine.cnblogs.com/articles/264172.html
不好意思 大家原谅
insert into openrowset('Microsoft.Jet.OLEDB.4.0',
'x:\A.mdb'';''admin'';''',A表) select * from 数据库名..B表/**//*************导入Access********************/
insert into B表 select * from openrowset('Microsoft.Jet.OLEDB.4.0',
'x:\A.mdb'';''admin'';''',A表)参考
http://singlepine.cnblogs.com/articles/264172.html