Append or Insert is the correct term. Rather than making a recordset, you can just run a query that selects data from the recordset's source and appends it to whatever table you choose. Since all the column names are the same, Access will automatically populate the Append To cells:
1. Create a new query.
2. Select the table or query that contains the records you want.
3. Select the columns you want from the source table.
4. Change the query type to Append. (query on the menu bar, then append)
5. If all the Append To cells populated for all the selected, you're done. If any are empty, you'll need to select the target field manually.
6. Save the query.
If you actually need to do this with a recordset (the query is more efficient and certainly easier to "code"), then you'll need to write either DAO or ADO code to add the recordset records to a table. Search help for .AddNew to find sample code.
