recordset handling question

[tdr]

I need to compare table 1 to table 2 and if different, write the entire row
from table 1 to table 3.


I can read an entire row from table 1 into a recordset using the following
strSQL_in = "select * from table1" ( and i can refer to the columns as
needed)

I have over 70 fields to compare and 100+ fields to write to table 3
how do I write the entire recordset to table 3?

strSQL_out = "insert into table3" + rsd! ( does not work )


TIA

 

[Klatuu]

Define "Different"
In other words, what makes the records different and what makes them the same?

 

[tdr]

different
name changes, or address changes, etc...

ex. table1 12345 fred stone 111 bedrock ave .........
table2 12345 fred stone 67 granet blvd .........

write
recordset 12345 fred stone 111 bedrock ave ........ to table3

and I don't/can't code a long insert statement defining all 100+ fields and
values
i.e. insert .... id, fname, lname, ....
values (Vid, Vfname, Vlname, ......
TIA