Try
COPY TO (gcDelimFile) FIELDS f1,f2,f3,...fn XLS
>hi,
>thank you,
>i try via vfp help as
>When the field list specified using COPY TO...FIELDS does not include the field that uses autoincrementing.
>
>i don't understand what i must do
>
>but i try as under, iget error messages
>
>COPY TO fields (gcDelimFile) XLS && error message Invalid path or file name
>
>COPY TO (fields) XLS && error mesage Variable "fields" is not found
>
>COPY TO (gcDelimFile)fields XLS && error mesage Variable "xls" is not found
>
>COPY TO (gcDelimFile.fields) XLS && error mesage "gcDelimFile" is not an object
>
>
>thanks.
>
>
>
>i try as
>>>hi all,
>>>
>>>any idea ,to convert mytable to excel book,
>>>
>>>just fields have data only,
>>>this code under convert all fields
>>>
>>>USE am2
>>>*GETFILE()
>>>
>>>gcDelimName = ALIAS( ) + '.xls'
>>>
>>>gcDelimFile = PUTFILE('excel_file:', gcDelimName, 'xls')
>>>
>>>IF EMPTY(gcDelimFile)
>>> CANCEL
>>>ENDIF
>>>
>>>COPY TO (gcDelimFile) XLS
>>>
>>>
>>>
>>>thanks.
>>
>>Check COPY TO command in Help. This command has FIELDS clause.