After doing a lot of investigating, it seems that loading a recordset into an empty table is a non-trivial task. I could find no good examples of it anywhere.

It seems the INSERT usage (either INSERT INTO or INSERT SELECT) will require naming every field. I'd like to avoid that. Then I thought about opening a second recordset from the empty table and loop through the first recordset using ADDNEW for the table recordset, but I don't know what syntax to use to assign the values. Would I need to loop through all the fields on each record?

Any help is greatly appreciated.

John