hi,
thank you,
about.. I don't know how to do this with the "import" command ? as..
thisform.text1.value=GETFILE('xls')
IMPORT FROM (thisform.text1.value) TYPE XLS
this can be automated (Automation from VFP)&& no idea how i can do it?
i can do that as example under...,
but the number of fields and fields names not the same every time.
CREATE TABLE test
( Clint_no n(15) ,name C(80) nocp, Tel C(10) nocp,category C(20)nocp, entity n(4) ,part2 c(2) nocp,dat d(8) )
APPEND FROM (thisform.text1.Value) TYPE xl5
thanks.
>>hi all,
>>
>>any idea, help
>>
>>when i make import from excel to dbf
>>
>>fields name as(no,name, telno,customer no...) change to a,b,c,d...
>>is ther away to keep the names as it is at dbf
>>
>>IMPORT FROM (thisform.text1.value) TYPE XLS
>>
>>
>>thanks
>
>I don't know how to do this with the "import" command, but you can open the spreadsheet in Excel and save it in DBF format. Of course, this can be automated (Automation from VFP).