USE dnc gnFieldcount = AFIELDS(gaMyArray) CLEAR FOR nCount = 1 TO gnFieldcount ? gaMyArray(nCount,1) alter(all field begin with Q to numaric type)&&& what kind of code i must write to do it? ENDFORthanks all the time
>*Read the Excel file into the cursor curtemp && Change the code you already use >Create table yourtable ... && With the structure you want >Append from dbf('curtemp')>Another approach is to use Afield() on the table, and then use Alter Table on each field which has a name beginning with q and whick is of type character.
>>as example >>use mytable >>locate for field name begin with q >>scan >>convert(alter) character type to numaric type >>endscan >>>>thanks again.