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>