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)  && Esc pressed
>>   CANCEL
>>ENDIF
>>
>>COPY TO (gcDelimFile) XLS   && Create delimited file
>>
>>

>>
>>thanks.
>
>Check COPY TO command in Help. This command has FIELDS clause.