>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)
> CANCEL
>ENDIF
>COPY TO (gcDelimFile) FIELDS char1 ,char3 , char7, char8, char9, char13 ,char25, char26, char27, char28 XLS
>
>
>
Not to beat a dead horse, but using meaningful names for database fields and form controls might have helped here. On the other hand, everything is now in place as you originally named it, so let's go from there. Try
SELECT char1 AS telno ,char2 AS name .... FROM am2 INTO CURSOR curTmp
COPY TO (gcDelimFile) 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)
>>>>> CANCEL
>>>>>ENDIF
>>>>>
>>>>>COPY TO (gcDelimFile) XLS
>>>>>
>>>>>
>>>>>
>>>>>thanks.
>>>>
>>>>Check COPY TO command in Help. This command has FIELDS clause.