1) by looping through the 'source' recordset and execting "INSERT INTO ..." against the Connection or Command objects
2) by opening the second recordset (based on the target table), looping through
the 'source' recordset and using .AddNew method
3) by inlcuding the sql statement behind the 'source' recordset into the "INSERT INTO.." and executing it, meaning:
INSERT INTO Table1 (Field1, Field2)
SELECT Field1, Field2 FROM Table2
"A diaper is not like a computer that makes satisfying burbling noises from time to time, hinting at great inner complexity." Malcolm Gladwell
"I'm sitting here completely surrounded by no beer." Onslow, 'Keeping up appearances'