Information générale
Catégorie:
Codage, syntaxe et commandes
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?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement