>>>>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 ;-)
Unless there are memos involved, of course ;-)
Anyway, as I said in the my first reply to Mel, and although the code I posted already took notice of the space in field names, that was just the fundamentals of the process. Naming is a problem, of course, even more because there are two set of naming rules involved (VFP's and XML's). Nothing that can't be solved with a minimum of effort, though.
----------------------------------
António Tavares Lopes