rafik

[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.

 

[Tim Ferguson]

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

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

HTH


Tim F