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

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?

... 1 Create object..........................ok 2 Reading row, (3) columns...............ok 3 Getting sheet name (Test Sheet1).......ok 4 Getting number sheets (3)..............ok 5 Dumping the entire spreadsheet: Expecting Sht1: 3 ... to come out as: 'Heading Col A', 'Heading Col C', 'Heading Col B' *** Test Sheet1 *** |Heading Col A|Heading Col C|Heading Col B |Sht1, Row 1, col 1|Sht1...

...Use it...........................ok 1 Create object....................ok 2 Reading row, (3) columns.........ok 3 Getting sheet name (Test Sheet1).ok 4 Getting number sheets (3)........ok 5 Dumping the entire spreadsheet: Expecting Sht1: 3 row x 3 col, Sht2: 2 row x 3 col, Sht 3: 1 row x 3 col: *** Test Sheet1 *** |Sht1, Row 1, col 1|Sht1, Row 1, col 2|Sht1, Row 1, col3 |Sht1, Row...

... 1 Create object..........................ok 2 Reading row, (3) columns...............ok 3 Getting sheet name (Test Sheet1).......ok 4 Getting number sheets (3)..............ok 5 Dumping the entire spreadsheet: Expecting Sht1: 3 ... to come out as: 'Heading Col A', 'Heading Col C', 'Heading Col B' *** Test Sheet1 *** |Heading Col A|Heading Col C|Heading Col B |Sht1, Row 1, col 1|Sht1...

...Use it...........................ok 1 Create object....................ok 2 Reading row, (3) columns.........ok 3 Getting sheet name (Test Sheet1).ok 4 Getting number sheets (3)........ok 5 Dumping the entire spreadsheet: Expecting Sht1: 3 row x 3 col, Sht2: 2 row x 3 col, Sht 3: 1 row x 3 col: *** Test Sheet1 *** |Sht1, Row 1, col 1|Sht1, Row 1, col 2|Sht1, Row 1, col3 |Sht1, Row...

... 1 Create object..........................ok 2 Reading row, (3) columns...............ok 3 Getting sheet name (Test Sheet1).......ok 4 Getting number sheets (3)..............ok 5 Dumping the entire spreadsheet: Expecting Sht1: 3 ... to come out as: 'Heading Col A', 'Heading Col C', 'Heading Col B' *** Test Sheet1 *** |Heading Col A|Heading Col C|Heading Col B |Sht1, Row 1, col 1|Sht1...

...Use it...........................ok 1 Create object....................ok 2 Reading row, (3) columns.........ok 3 Getting sheet name (Test Sheet1).ok 4 Getting number sheets (3)........ok 5 Dumping the entire spreadsheet: Expecting Sht1: 3 row x 3 col, Sht2: 2 row x 3 col, Sht 3: 1 row x 3 col: *** Test Sheet1 *** |Sht1, Row 1, col 1|Sht1, Row 1, col 2|Sht1, Row 1, col3 |Sht1, Row...

...Use it...........................ok 1 Create object....................ok 2 Reading row, (3) columns.........ok 3 Getting sheet name (Test Sheet1).ok 4 Getting number sheets (3)........ok 5 Dumping the entire spreadsheet: Expecting Sht1: 3 row x 3 col, Sht2: 2 row x 3 col, Sht 3: 1 row x 3 col: *** Test Sheet1 *** |Sht1, Row 1, col 1|Sht1, Row 1, col 2|Sht1, Row 1, col3 |Sht1, Row...

...Use it...........................ok 1 Create object....................ok 2 Reading row, (3) columns.........ok 3 Getting sheet name (Test Sheet1).ok 4 Getting number sheets (3)........ok 5 Dumping the entire spreadsheet: Expecting Sht1: 3 row x 3 col, Sht2: 2 row x 3 col, Sht 3: 1 row x 3 col: *** Test Sheet1 *** |Sht1, Row 1, col 1|Sht1, Row 1, col 2|Sht1, Row 1, col3 |Sht1, Row...