Copying Recordsets using DAO

[Mithyrl]

Just a quick question.
I have a DAO recordset and I want to copy the entire recordset to a new database.
The new database is an empty template of the recordset...meaning it has all the same fields.

The question is what is the most simple and efficient way of doing this?
Stepping through each of the records and writting them individually to the database? OR Is there a way to just copy over the whole thing?

[Jaguar]

Yes - you need to cycle through the complete recordset and move the data over to the other database. Unfortunately there is no way to simply tell the recordset to copy itself over. This must be written, and once it is, of course, it would be completely transparent to someone.

Somebody else have an idea?