aspose file tools*
The moose likes JDBC and the fly likes Oracle 9i to Excel Sheet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle 9i to Excel Sheet " Watch "Oracle 9i to Excel Sheet " New topic
Author

Oracle 9i to Excel Sheet

manohar amrutkar
Greenhorn

Joined: May 15, 2007
Posts: 5
Dear Friends,

I need to put data from Oracle 9i database to an excel sheet which has a fixed format of columns. I want to update excel sheet whenever there is change in Oracle database through front-end. Please tell me what are different ways to do this and how to do the same??

Thanks.
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2510
    
  10

The easiest way might be to to use odbc.
You can use excel's Get External Data functionality to fill the spreadsheet with Oracle's data.
Excel provides a refresh button. When the user presses it, the spreadsheet is refreshed from Oracle's data.

Another way is to use Oracle Discoverer. It allows you to query the databace and export the result to excel - interactive and in batch mode.

I don't know a tool that automaticaly updates excel when Oracle data is changed.

Regards, Jan


OCUP UML fundamental and ITIL foundation
youtube channel
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Oracle 9i to Excel Sheet