hi,
But why don't you simply save as dbf from Excel??
becuse i have fields have arabic characters(names ,addresses,city....)
with this way, convert it to rubbish data
thanks,
regards
m.qasem
>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>