Re: Exporting ADOQuery Results to Excel


"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MySpread***.xls;Extended Properties=Excel 8.0;Persist Security Info=False"

Set the connection string property to the above string - the Excel 8.0 value for the extended property depends on the version of Excel you are using IIRC the 8.0 applies to Office 2k versions and up.

You can use the connection string builder just remember to go to the All page and add the Excel 8.0 value to the extended properties option.

You can now select a sheet in the TableName property of the ADO table. The available sheets will appear as the table names postfixed with a "$" as mentioned previously.

"Nirmal Singh" <nirmal.singh@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
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