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.