Re: Tools to populate spreadsheet(report) from oracle database

Mark (joystar.jin_at_gmail.com) wrote:
: 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.

Write a VB function for the spread sheet. The function can run each query and assign the results to the correct cells (after which the spread sheet can do what ever calculations it needs to do).

To figure out how, you record a macro and then step through all the steps to manually populate one cell from the database. There is another option that lets you examine the macro you just ran. It will be VB code and you can edit it.

--

This space not for rent.