Hi Raza,
>Hello!
>
>Does someone can guide me through extracting data from an Execl spreadsheet with multiple work sheets. For example I get a spreadsheets called Orders.xls. I has three
>work sheets Customers, Order Header & Order Line Items.
>
>Thanks In Advance
>
>Raza Malik
>razam@u-a-s.com
Try to use Import command. VFP 8 have sintax with
Sheet
parameter, see if VFP 7 have it too. Sample:
Import From Orders.xls Type XL5 Sheet Customers
The dbf created have the name Orders.dbf. You can to change the name of the Sheet to get other sheets. See VFP help.
Good luck!
Erick
Força Sempre!
Strength Always!