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&&syntax error
>>>>

>>>>
>>>>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 ... && Fill in the code to create the correct structure
>>>lcFile=thisform.text2.value
>>>APPEND FROM (lcFile) CSV>