Populate page(report) from oracle database

My work needs to run queries on Oracle databases to generate report.

The report here I mean, may not has the same meaning as oracle report. The report I mean is basically in excel format to summarize the database.

The figure in each cell of the spreadsheet is resulted from a query on oracle database. There are a lot of queries need to run in order to get the whole spreadsheet. And the same thing needs to be repeated every month, by only changing the month value in the query.

I am wondering is there a way to connect each query to excel speadsheet, and automatically generate this report? I did this kind of thing in Access before by using Access report. After setting up the access report, the whole report page can be generated by just one click. And the user can just key in the month value to get the report.

Thanks,

Matt Received on Tue Jan 18 2005 - 09:22:56 CST