Using the INSERT INTO Statement

In a recent forum message, VTHOME2009 wrote:

"I would like to use the INSERT INTO SQL statement to export data from a temporary table in Access to the destination table in Access. I do not want to type in the field names or the values in the INSERT INTO statement since the temporary tables and destination tables change as the code runs.

Is there a way to write VBA code that will insert the field name and value into the INSERT INTO statement?"

Can you help? Interested in answers to the same question? Visit the About Databases forum and join the discussion!