recordset handling question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Define "Different"
In other words, what makes the records different and what makes them the same?
 
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
 
Back
Top