This might help you as well.

open database d:\test\test

CREATE CONNECTION TESTEXCEL ; 
   CONNSTRING "DRIVER=Microsoft Excel Driver (*.xls)"

CREATE SQL VIEW "TESTEXCELSHEET1" ; 
   REMOTE CONNECT "TESTEXCEL" ; 
   AS SELECT * FROM "Sheet1$" Sheet1_

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