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