How can I append records (specific rows, with multiple (but not all) columns) from one table to another
===

Each day ~5000 records are uploaded to tblRecordsCurrent, at some point within the next few days when those records have been processed, they need to be moved to tblRecordsHistorical.  Each record has a Foreign Key `DataSetID` that ties it to the date/time it was uploaded (Parent Table).

How, within vba, can I insert a single DataSet of tblRecordsCurrent into the tblRecordsHistorical from tblRecordsCurrent.  I cannot insert all columns as both tables contain persisted columns.

I can't put the entire `INSERT INTO tblRecordsHistorical A, B, C, D, E, F...` as it is too long for access vba.

Any ideas?

