Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy all fields including memo fields to .CSV file
Message
From
16/05/2003 15:38:02
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00787545
Message ID:
00789433
Views:
18
Bill,
I don't know of any "reverse" example, but it shouldn't be too hard to write.

No, your append won't work. First, the syntax isn't quite right - instead try:
Append From (gcDelimFile) Delimited With " With Character ,

Next, as the test code I tried shows, VFP just skips over memo fields in an APPEND.
CREATE TABLE testappend (field1 C(10), Field2 N(10), field3 M, field4 C(250))
modi file testappend.txt
"ABC",1,"ABCDEFGHIJKLMNOPQRSTUVWXYZ"
"DEF",2,"ABCDEFGHIJKLMNOPQRSTUVWXYZ"

gcDelimFile = "testappend.txt"
Append From (gcDelimFile) Delimited With " With Character ,
Puts nothing into Field3 the 2nd string goes into Field4. I also tried it with:
"ABC",1,"ABCDEFGHIJKLMNOPQRSTUVWXYZ", "QQQQ"
"DEF",2,"ABCDEFGHIJKLMNOPQRSTUVWXYZ", "ZZZZZ"
And it just ignored that "4th" field.

Rick

>Thanks Rick
>I'll try it. By yhe way, How do you re-construct a vfp table from the resulting .CSV file?
>Will the following work? I have a feeling it will ignore the memo fields when constructing the .DBF.
>
>append from (gcDelimFile)
> delimited with """ with character ','
>
>Bill
Previous
Reply
Map
View

Click here to load this message in the networking platform