Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel 97 - 2000 + ADO Recordset
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00748147
Message ID:
00748276
Vues:
21
>Is it possible to pass an ADO Recordset to Excel 97/2000 and show the records in excel from VFP 7 ?

Stephane,

With Excel 2000 you can use CopyFromRecordset method. In Excel 97 this method supports only DAO recordsets and you'll need to copy data into array using the GetRows method, and then fill the cells from array. These approaches are described in KB articles Q246335 and Q247412. VFP sample for Excel 2000 you can find in file #10002 (dbc2xls.prg).

Alexander
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform