Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import csv file
Message
From
13/09/2006 10:17:00
 
 
To
13/09/2006 10:09:51
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01153299
Message ID:
01153307
Views:
24
>hi all,
>
>any idea,help
>i try to import file.csv as under
>
>*IMPORT FROM (thisform.text2.value) TYPE XLS
>IMPORT FROM (thisform.text2.value) TYPE csv&&syntax error
>
>
>thanks

You can not import from a CSV file, because it does not contain information about field names. SO you must first create a cursor/table, and APPEND into it.
*IMPORT FROM (thisform.text2.value) TYPE XLS
create cursor ... && Fill in the code to create the correct structure
lcFile=thisform.text2.value
APPEND FROM (lcFile) CSV>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform