I'm sorry, but Excel XML is not usable because it has its own standard, which I did not know. But why don't you simply save as dbf from Excel?
>hi,
>thank you,
>i save it as xml?
>i try via import nothing as xml?
>what the steps.
>
>regards.
>m.qasem
>>The easiest and most flexible, is to use XML.
>>
>>>hi,
>>>thank you for reply help and code,
>>>
>>>i think i can do that as excel...,
>>>
>>>but via this code i need to know every field to create the cursor,
>>>
>>>i think it is better to save it as excel and i can make import next...
>>>
>>>thanks alot.
>>>
>>>m.qasem
>>>>>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
>>>>>
>>>>>
>>>>>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 ...
>>>>lcFile=thisform.text2.value
>>>>APPEND FROM (lcFile) CSV>