hi,
thank you very much,it works,

if my fields as char1,char2....etc

any way to change(rename) title of XLS.fieldS as char1=telno,char2=name....

via same code

USE am2
*GETFILE()
gcDelimName = ALIAS( ) + '.xls'
gcDelimFile = PUTFILE('excel_file:', gcDelimName, 'xls')
IF EMPTY(gcDelimFile)  && Esc pressed
   CANCEL
ENDIF
COPY TO (gcDelimFile) FIELDS char1 ,char3 , char7, char8, char9, char13 ,char25, char26, char27, char28   XLS

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

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