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

[E-Link]

if Table2 has same structure as Table1 , u can do it with Sql Statement , like this :

SQL = "INSERT INTO Table2 SELECT * FROM Table1"

[tonio]

im copying from a recordset not table. my recordset contains filtered records from a table.

[Wokawidget]

   Set adoRecordset2 = adoRecordset1

Where adoRecordset2 & adoRecordset1 are ADODB.Recordset

Why would you want to copy a recordset to another?

E-Link: That plane didn't exist. The flight number is made up