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?