one recordset to another

[tonio]

hi,

is there a better way of copying records from a recordset to another recordset aside from using this code:

do while not rsOne.eof
rsTwo.addnew
rsTwo!FieldName1 = rsOne!FieldName1
.
.
.
rsOne.MoveNext
Loop