writing a record set to a access table

[numbenator]

Hi,

How do I update a Access table with a recordset?

My problem is I am creating an archive table. I wish after selecting all records to be archived to copy them to a duplicate tabel that i have already created.

cheers.

[numbenator]

sorted!
Managed to suss out