Best way to save the records

[Desperate]

What is the best way to save data from one temporary table to the main table? An append query? An sql statement in vba code? by recordset? saverecord macro? or anything else I forgot to mention here. By "best way" I mean performance and timing considering you have thousands of data to save at once. And also I am talking about a datasheet with full of rows.

 

[KenHigg]

I see no reason why a pre-built append query wouldn't be the best - ?

 

[c_smithwick]

As a general rule with regard to performance, temporary tables are a BAD idea - they lead to bloat and corruption and should be avoided. You can usually accomplish the same thing with a carefully designed update or append query or some creative VBA coding if you need to temporarily hold data while processing it before permanently storing it in a table.