Abraham -
Check out this video and the extended cut for Add Records Automatically.
https://599cd.com/blog/display-article.asp?ID=1445

Richard doesn't use recordset in the videos but it is pretty straight forward and you should be able to loop through adding records with recordsets.

Yep. A simple append query will work.