Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
EXCEL with MULTIPLE WORKSHEETS
Message
From
03/10/2005 12:20:40
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brazil
 
 
To
03/10/2005 12:05:02
Raza Malik
Universal Accounting Software
Edgewater, New Jersey, United States
General information
Forum:
Visual FoxPro
Category:
Third party products
Environment versions
Visual FoxPro:
VFP 7
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01055537
Message ID:
01055544
Views:
8
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!
Previous
Reply
Map
View

Click here to load this message in the networking platform