Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle output to excel
Murtuja wrote:
> I want daily report in Excel format.and this excel file should be
> mailed to client.I want autoamtic process for that just like cron job.
>
> I am using Oracle 9i on Linux
>
I think the simplest method has been overlooked. Why not retrieve the data as external data right from excel via an ODBC query and save the query? You can refresh it every day when you open the spreadsheet.
-- To reply by email remove "_nospam"Received on Fri Feb 03 2006 - 13:50:39 CST