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