Append array to recordset

[Tom]

I am looking for an easy way (without sql) to append then delete records from
a set like the following. Is there a way i can do this?

rs2.AddNew (rs1.fields, rs1.Getrows(1))


then remove the row i just moved.

Thanks

Tom

 

[Tom]

If i could collect multiple rows into an array (seperate rows, not next to
each other) then append to a recordset, it would be perfect!

Thanks

Tom