how to add data from one table to another

[Alex]

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

Thanks

 

[John Spencer (MVP)]

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.

 

[Alex]

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.

.