Re: Exporting ADOQuery Results to Excel

Bill

I would appreciate any help you can give me with this.

I have an open ADOQuery1 with the results of a query against an Oracle
database.

I have created a dummy spread*** c:\test.xls. How do I get the results of
ADOQuery1 into sheet1 of the spreadsheet?

I have tried creating a new spread*** via automation and inserting the
data values into the individual cells, but that is just too slow.

Nirmal

"Bill Todd [TeamB]" <no@xxxxxx> wrote in message
news:483eb570@xxxxxxxxxxxxxxxxxxxxxxxxx
You can control Excel via Automation.

You can use the Excel ODBC driver with the ADO components.

--
Bill Todd (TeamB)


.

Quantcast