i'll give try.
thanks
>>thank you,
>>about,
>>Create table yourtable ... && With the structure you want
>>Append from dbf('curtemp')&& evrey time i need to import deffierent excel
>>sheet(mean some excel sheet have q1 to q15, another sheet have q1 to q30 or more ...etc,
>>that's mean i must add another fileds if more q,as manualy..
>>
>>what i need if it can, at the same code as program
>>
>>import excel sheet to vfp.dbf
>>convert every fileds begin with q
>
>AFAIK you have to do this in steps, like I explained. But I do it myself in many places, it's easy and fast, especially if you use cursors wherever possible.
>
>>anyway thank you very much.
>>
>>
>>
>>
>>
>>
>>
>>>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
>>>Create table yourtable ...
>>>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.