how to add data from one table to another

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Can anybody advise how to add data (whole table) from one
(temporary) table to another (permanent)?

Thanks
 
Probably by using an Append (INSERT INTO) query. The exact syntax would be
difficult to say without more understanding of the table structures.

INSERT Into SomeTable (FieldA, FieldC, FieldR)
SELECT FieldX, FieldY, FieldZ
FROM TemporaryTable

This should put FieldX into FieldA, FieldY into FieldC, and FieldZ into FieldR.
 
Thanks a lot.

-----Original Message-----
Probably by using an Append (INSERT INTO) query. The exact syntax would be
difficult to say without more understanding of the table structures.

INSERT Into SomeTable (FieldA, FieldC, FieldR)
SELECT FieldX, FieldY, FieldZ
FROM TemporaryTable

This should put FieldX into FieldA, FieldY into FieldC, and FieldZ into FieldR.

.
Click to expand...
 
Back
Top