Copy columns from table 1 to table 2

[Mbroad]

Hi-
I need to copy certain columns from table-1 to table-2, each table having a different file layout. Is there a method to copy specific fields from table-1 and place them in different columns on table-2?

Your help is greatly appreciated.

MB

Government Coder Mark

 

[gmmastros]

Do you want to add records to table 2, or are you updating records in table 2.

To add records to table2...

[tt]Insert
Into Table2(FieldA, FieldB)
Select Field1,
Field2
From Table1
Where SomeCondition = 'Whatever'[/tt]



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Mbroad]

Thanks--I am inserting records--I will give this a try and let you know---Mark

Government Coder Mark