Re: Exporting ADOQuery Results to Excel

I now have two ADOQuery components on my form, Query1 with the results of a
query against an Oracle database, Query2 pointing to a blank *** in an
excel spread***. How do I tranfer the results of Query1 to Query2 and
then to the spread***?

Most of the search results I have found deal with transferring data within
sheets in an excel spreadsheet or from Acces to Excel.


Nirmal



"Ken" <kbsubsNotThisPart@xxxxxxxxxxxxxxxxxx> wrote in message
news:483fa460$1@xxxxxxxxxxxxxxxxxxxxxxxxx

"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 *** 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