B boylafong Unregistered / Unconfirmed GUEST, unregistred user! 2010-01-08 #1 有2个数据库文件, a.mdb和b.mdba和b都有同样的表mytest,数据不一样,如何把b的mytest表覆盖掉a的mytest表?
Z zhengrong117 Unregistered / Unconfirmed GUEST, unregistred user! 2010-01-08 #2 1. drop a.mytest select into a.mytest from b.mytest2. delete * from a.mytest for ... insert .....http://www.cnblogs.com/freshman0216/archive/2008/08/15/1268316.html
1. drop a.mytest select into a.mytest from b.mytest2. delete * from a.mytest for ... insert .....http://www.cnblogs.com/freshman0216/archive/2008/08/15/1268316.html
B boylafong Unregistered / Unconfirmed GUEST, unregistred user! 2010-01-08 #3 已经解决了,不过不是覆盖掉表,而是把表中内容先删除再插入先用adoqA执行 delete * from mytest,然后用adoqB执行insert into [c:/a.mdb].mytest select * from mytestadoqA关联a.mdb adoqB关联b.mdb
已经解决了,不过不是覆盖掉表,而是把表中内容先删除再插入先用adoqA执行 delete * from mytest,然后用adoqB执行insert into [c:/a.mdb].mytest select * from mytestadoqA关联a.mdb adoqB关联b.mdb