>To all-
> Does anyone know of a way to append comma-delimited text files into VFP memo fields? I have a table called "Import.dbf" that receives information from a text file called "Export.txt". I have set certain fields to MEMO type in "Import" to capture long strings of info from "Export", but when I append from the text file into the table, the memo fields are ignored and the long string of info gets placed into the next available character type field. Is this a bug in VFP that has no workaround, or is there a way to fix this?
> By the way, this is something that has to be done programmatically so I can't turn to the import wizard for assistance.
> Also, if anyone has a comprehensive way to correct errors in comma-delimited text files, I would definitely like to hear about it. I have a situation where I am dealing with a third party vendor who supplies me with a text tile, and they have embedded carriage returns within file where they should not be. I have fixed this problem but there seem to be other problems cropping up with this file. I don't want to fix it as I discover new problems, but instead want to know if anyone out there has ever had to develop a program for cleaning up text files that need to be imported into tables.
Hi Charlie,
MEMO fields are always ignored when appending a text file. To insert data into a MEMO field you have to use APPEND MEMO (filename). Check the help file for additional details.
hth,
George
Ubi caritas et amor, deus ibi est