>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.