Thierry ---

First off, replace the NEXT clause with a WHILE or FOR clause that does the same thing. Secondly, there is no TYPE XL5 in 2.6, use TYPE XLS (Excel version 2 file .. should be usable).

The end result:

COPY TO tempsh.XLS FIELDS sp.pathname FOR {whatever works} TYPE XLS


>I'm working between both FoxPro 2.6 and 6.0. I'm a little more familiar with syntaxes for 6.0 and am struggling with getting a piece of code to work with 2.6. Any assistance in determining what needs to be changed to make the following code work with 2.6 would be muchly appreciated. Thanks.
>
>copy to "TEMPSH.XLS" fields SP.PATHNAME next 1 type xl5
>
>
>Thierry