Adding a Recordset to a Table??

[peet]

db2.execute "INSERT INTO myTargetTable 
SELECT * FROM mySourceTable IN 'c:\SourceDB.mdb'"
 
db2.execute "DELETE * FROM mySourceTable IN 'c:\SourceDB.mdb'"