Database to Excel

aravinth · #1 (**permalink**) 02-14-03, 11:35

Hi,

I want to place Oracle data in an excel worksheet through programming java. Has anyone a solution for this?

Thanks for your help.

aravinth

jef72 · #2 (**permalink**) 03-03-03, 17:25

I used OLE from Oracle Forms to send data to excel. It worked fine.

Do you want to push the data from the Oracle DB to excel or from an apps ?

You can also use ODBC into Excel VBA modules to grab data from Oracle.

I hope it'll help you.

Quote:

Originally posted by aravinth
Hi,

I want to place Oracle data in an excel worksheet through programming java. Has anyone a solution for this?

Thanks for your help.

aravinth

sathyaram_s · #3 (**permalink**) 03-04-03, 06:20

This article was written for DB2, but I don't see a reason why this will not suit Oracle ...

http://www7b.boulder.ibm.com/dmdd/li...302bhogal.html

Sorry if I have missed something

Cheers

Sathyaram

ihv · #4 (**permalink**) 03-05-03, 03:58

Quote:

Originally posted by jef72
I used OLE from Oracle Forms to send data to excel. It worked fine.

Hi!

I'm using Forms 6 and it can't display raw files (that come from database blob column) in OLE item, only those ones are shown which is saved by Forms itself (I looked the content and it seems that forms is formatting those files on its own way). Is there any solution to open raw files in forms using OLE?

Internet Services

Web Development

Digital Marketing

Consumer Tech