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

Yes :( Unfortunately I don't know if there is a simplier way when column counts do not match.
Cetin