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>