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