Author: Dan FreemanDan Freeman Date: Sep 16, 2008 13:44
The source code for the Wizards (including import) ships with VFP. (Look for
xSource.zip in the tools folder somewhere.) You could "borrow" from that.
Or you could fiddle with variants of:
APPEND FROM (filename) SHEET "Sheet name"
Dan
Sunny wrote:
> I have bunch of excel files with 10-15 sheets in each file. I would
> like to import all data from each sheet and each file to foxpro
> table. I can do it with import wizard but it is too much for each
> sheet. I want to write program which can read all data. something
> like select * from excelfile1.sheet1, Is there anything like this?
| 
