Hi Yuri,

I finally ended up exporting the table to a fox2 format, importing into Crystal Reports 8.5 and exporting to comma delimited from Crystal. The memo fields export just fine from Crystal.

Thanks for your help,


>If the comma delimited file is the only option, then the only way I see is to get file from the final cursor/temporary table where memofield is converted to character.
>Details depend on what is the max length of the memo field. If it is less than 254, then the content of the entire memo field may be converted, otherwise you need to split memofield into several columns.
>
>>Hi Yuri,
>>
>>Thanks for the information. The question still remains, however, How do I export memo fields to a comma delimited file? Is there some other command that I can use? The person to whom I am sending this information can not read .dbf files with their application. They need a comma delimited file. Is this possible?
>>
>>Thanks,
>>
>>
>>
>>>As in VFP Help on COPY TO:
>>>
>>>"If the file you are creating is not a table, memo fields are not copied to the new file, even if memo field names are included in the field list"
>>>
>>>
>>>>Hello,
>>>>
>>>>I have a table with some character fields and some memo fields. I want to put the data in a comma delimited .txt file.
>>>>
>>>>When I issue the COPY TO test TYPE DELIMITED command, all of the fields EXCEPT the memo fields are exported to the document.
>>>>
>>>>QUESTION: How do I get the memo fields to export to the document?