>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