Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel 97 - 2000 + ADO Recordset
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00748147
Message ID:
00748276
Views:
13
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform