Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle 9i to Excel Sheet

 
manohar amrutkar
Greenhorn
Posts: 5
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2574
11
C++ Linux Netbeans IDE
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic