one recordset to another

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

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

Code:

---

SQL = "INSERT INTO Table2 SELECT * FROM Table1"

---

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

Code:

---

  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 :)