Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append From
Message
From
21/04/2005 09:21:37
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows 2000
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01006950
Message ID:
01006953
Views:
23
>Hi -
>
>I just would like a confirmation on something I noticed and also, would like to know if there is a fix available. Thank you.
>
>Does the command " Append from "xxxx.csv" type csv " automatically drop the first line/first record?
>
>I have a data file without the header row at the top. When I use the command " Append from "xxxx.csv" type csv " to pull data into a table it drops the first line.
>
>Yet when I use the command "Append from xxxx.csv type delimited with character ," to pulls in all rows.
>
>Has anybody observed this before and is there a fix available so I can continue using " Append from "xxxx.csv" type csv " command? Thank you.
>
>Neetu Kumar

From the VFP 8 help file:
" A CSV file has field names as the first line in the file; the field names are ignored when the file is imported. "

HTH,
Jim
Previous
Reply
Map
View

Click here to load this message in the networking platform