>hi all,
>
>i need to convert to txt delimited with # via vfp code,
>
>this code below convert to excel sheet
>
>

>SELECT txp_no as txp_no,year as year,id_no as id_no,id_type as id_type,inf_type as inf_type,cnt_code as cnt_code ,;
>dedcode as dedcode,AMT as AMT ,entry_id as entry_id,entrydate as entry_date,confflag as confirm_flag,confirmid as confirm_id,confdate as confirm_date FROM qcombined1 INTO TABLE MYcur
>
>gcDelimName = ALIAS( ) + '.xls'
>
>gcDelimFile = PUTFILE('excel_file:', gcDelimName, 'xls')
>
>IF EMPTY(gcDelimFile)  
>
> CANCEL
>
>ENDIF
>COPY TO (gcDelimFile) XLS
>
>

>thanks

Hi Mohammed,
did you try this command:
COPY TO (your_txt_file_name) TYPE DELIMITED WITH CHARACTER #