rafik

A

Append table

hi,
i created a table for temp entries, befor closing the temp
table i like to give the user the option to append an
existing table with the new tata from the temp table.
what is the command to do that
thank you.
 
T

Tim Ferguson

append an
existing table with the new tata from the temp table.
what is the command to do that
Click to expand...

INSERT INTO ExistingTable
(FieldOne, FieldTwo, FieldThree)
SELECT FieldA, FieldB, FieldC
FROM TempTable

HTH


Tim F
 
Top