Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Putting data in Oracle databases into Excel Workbooks

Putting data in Oracle databases into Excel Workbooks

From: <hgcphoenix_at_my-deja.com>
Date: Sat, 23 Sep 2000 13:09:09 GMT
Message-ID: <8qia1d$o5e$1@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 Sat Sep 23 2000 - 08:09:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US