General information
Category:
Coding, syntax & commands
>>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only