db1:excel库,内有表table1 field1,field2
db2:access库,内有表table2 field3
adoconnection1连接db1
adoconnection2连接db2
adoquery1.connection:=db2;
下面是查询的语句:
select field1 from excel表的table1 where field2 not in field3
该怎样连接这个excel表呢?
db2:access库,内有表table2 field3
adoconnection1连接db1
adoconnection2连接db2
adoquery1.connection:=db2;
下面是查询的语句:
select field1 from excel表的table1 where field2 not in field3
该怎样连接这个excel表呢?
//while not eof do string:= string+fieldByName('field3').asString+','......
'select field1 from execelbiao where field2 not in '+String;