Sorry, but I donæt have the time to give you the code. But the easiest is to read the data from the excel file into a temp cursor, and then append the data from the temp cursor into a table which you have already created with the correct structure. In semicode, which is NOT ment to work, only show you briefly:

*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.

>thank you for reply,
>
>i mean something as vfp code(program),if it is possible
>

>as example
>use mytable
>locate for field name  begin with q
>scan
>convert(alter) character type  to numaric type
>endscan
>

>thanks again.
>>>hi all,
>>>
>>>after import an excel sheet to vfp.dbf,
>>>i have many fileds begin with q as q1,q2,q1a...etc.. all fields is characters type , i need to change all fields begin with q to numaric type .
>>>
>>>thanks for help.
>>
>>Look up the command Alter Table in help.