Re: Putting data in Oracle databases into Excel Workbooks

From: Walter Dorninger <walter.dorninger_at_aon.at>
Date: Sun, 24 Sep 2000 18:32:27 +0200
Message-ID: <8qlaek$1ake$1@wrath.news.nacamar.de>

I don't know exactly what you are trying to accomplish with developer 2000 but if you are trying to export oracle data to a excel worksheet try Oracle Objects for OLE(http://technet.oracle.com)

Walter Dorninger

<hgcphoenix_at_my-deja.com> wrote in message news:8qia0c$o59$1_at_nnrp1.deja.com...
> Hello everyone,
>
> I hope someone can help me with this dilemma. This would have been
> easier if we were using Visual FoxPro or Visual Basic. We are using
> oracle and developer 2000.
>
> The problem is that the data is in Oracle databases and we need to
> export this data into excel workbooks.
>
> What we've managed to do is perform a query and output the result to an
> excel file. Unfortunately, the data has to be placed into an existing
> file in the correct columns and rows.
>
> In VFP, we use the creatobject function to call on the Excel
> application and perform a loop through a table of records while copying
> the data into the workbook.
>
> Does anyone know whether there is something similar to "createobject"
> in developer 2000.
>
> Thanks
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Sun Sep 24 2000 - 11:32:27 CDT