>Hi All !
>I have to copy data from table1 to table2. Both tables are in SQLServer database. The table2 is simply table1 with a slightly midified structure. In VFP I can use one simple command Append from .... What is the best way to do it using SQLServer commands ? Thanks in advance.

insert into table2 select ... from table1 ...

Cetin