Exporting query results to Excel

[Quest_4_Oracle]

Hi,

My job is to generate reports on regular basis.
As of now I am running the queries and using the "EXPORT TO" option of the tool, generating the reports in EXCEL.

So, Is there any option to directly generate the reports by running some commands or to automate this process???

 

[Marco Kalter]

You can use the Excel or Excel2007 parameter. For example:

"C:\Program Files\QueryReporter\QueryReporter.exe" userid=scott/tiger@chicago exec=c:\reports\deptemp.rep excel quit