Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating table from CSV
Message
From
06/11/2016 06:33:13
Thomas Ganss (Online)
Main Trend
Frankfurt, Germany
 
 
To
06/11/2016 02:06:11
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01642781
Message ID:
01642797
Views:
45
>>>It's interesting that VFP has no support for programmatically IMPORT from CSV, when it is capable of import from more complex file formats.
>>
>>It has such comamnd. Create table with fields in same order as in csv file and use
>>
>>append from csvfile delimited
>>
>>or similar to import.
>
>I think you're missing the point of the thread. Mel does not know about the structure of the CSV file, or it can be a lot of things, so he cannot CREATE and APPEND.

Such files often happen to have some irregularities: think spaces in field names for example. I find the approach to analyze/create via the wizard better: atfer first import I check save the table structure plus sometimes a small prg to clean specific issues. Next import goes easier ;-)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform