my dog learned polymorphism
The moose likes JDBC and Relational Databases 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

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Oracle 9i to Excel Sheet " Watch "Oracle 9i to Excel Sheet " New topic

Oracle 9i to Excel Sheet

manohar amrutkar

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??

Jan Cumps

Joined: Dec 20, 2006
Posts: 2562

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
I agree. Here's the link:
subject: Oracle 9i to Excel Sheet
jQuery in Action, 3rd edition