有如下两个Access数据库DB1和DB2
DB1中有表t1
DB2中有表t9,t10现在要将DB2中数据按如下要求导出到DB1中:
INSERT INTO t1
FROM t9,t10
where t9.column1=t10.column
如何进行这种操作?
DB1中有表t1
DB2中有表t9,t10现在要将DB2中数据按如下要求导出到DB1中:
INSERT INTO t1
FROM t9,t10
where t9.column1=t10.column
如何进行这种操作?
调试欢乐多
ADOQuery1.SQL.Text := 'INSERT INTO t1 in ''d:= DB1.mdb'' FROM t9,t10 where t9.column1=t10.column'
www.delphiboy.comDelphi资源下载:
http://www.delphifans.com/down.aspDelphi经典编程百例
http://www.yesky.com/SoftChannel/72348977504190464/20030506/1667075.shtml