>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.
You can not put data into the Memo field with this command AFAIK. Make this field to be character.
If it's not broken, fix it until it is.
My Blog