hello, I am using ADO to connect to two databases and I have a question. I have two connections, one for each database. Each database has two identical table templates.. is there a way to insert into table1 of database1 the records from table1 of database2 where field1 of database2 does not match field1 of database1? please help if you can, thanks!

Thai