Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to append from comma delimited text
Message
From
21/11/2008 10:53:07
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01363489
Message ID:
01363502
Views:
17
>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't. The Append from command doesn't load memo fields from text files or csv files.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform