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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham