Hi Kevin,
You can do this in VFP.
create cursor test (f1 i, f2 i)
insert into test values (1,1)
insert into test values (2,2)
insert into test values (3,3)
copy to c:\testnew xl5
copy structure to c:\testnew
use c:\testnew
suspend && open in excel, change, resume
* IMPORTANT!!!
* - Remove the column headers (ie F1,F2)
* - Dont do anything that will modify the structure (ie. move columns around)
append from c:\testnew xl5
HTH.
>The last part, the modify and to copy a table to type xls format is easy, but is there any easy way to open an excel file as a formated table in VFP so that I can modify, add columns, etc. then return the results to excel. The only part I would need to know is how to open an excel file up as a table in VFP or somehow copy it in a way to convert it that I can open it.
ramil
~~~ learning to stand still ~~~
Well actually the only part I needed was to know that you can append from an excel file into a dbf. I was not aware you could do that. And I assume that it appends in the order of the excel sheet matching the columns to fields, so column 1 would be put into the first field, and I would also assume that when it is transfered that it will automatically convert to the format of the field the column is dropped into. But this is what I needed, thanks
``` Appreciate a normal day, it is always better than a bad one ```
Kev