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.