Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
EXCEL with MULTIPLE WORKSHEETS
Message
De
03/10/2005 12:20:40
Erick Miranda
Formata Data Business - Grupo Linx
Contagem, Brésil
 
 
À
03/10/2005 12:05:02
Raza Malik
Universal Accounting Software
Edgewater, New Jersey, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Produits tierce partie
Versions des environnements
Visual FoxPro:
VFP 7
Database:
Visual FoxPro
Divers
Thread ID:
01055537
Message ID:
01055544
Vues:
15
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!
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform