Good morning,

I need to create some VFP tables from text files. The text files were created by another application by running export to "comma delimited" file.

Here are a couple of lines in one text file:

1,"Housekeeping","Housekeeping for WinOS","","","W"
2,"Maintenance","Maintenance for WinOS","","","W"
3,"Dispatch","Dispatch for WinOS","","","W"

What I did is created a table with the following structure:
fld1, N, 6, 0
fld2, C, 50
fld3, M
fld4, C, 1
fld5, C, 1
fld6, C, 2

Then I run the following command

select MyNewDbf
append from mytestfile.txt csv

The problem is that all but my MEMO field get the data. How do I make the APPEND FROM retrieve the data from the text file into the MEMO field?

Thank you in advance for any help.