Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2003
    Posts
    1

    Unanswered: Database to Excel

    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

  2. #2
    Join Date
    Mar 2003
    Location
    Belgium
    Posts
    9

    Re: Database to Excel

    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.

    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

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Database to Excel

    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

  4. #4
    Join Date
    Mar 2003
    Posts
    1

    Re: Database to Excel

    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •