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


Hi Cetin. Thanks
Insert into table2 select ... from table1 ... semms to be much more demanding as regards as field list then VFP append from.