Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle output to excel

Re: oracle output to excel

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Fri, 03 Feb 2006 19:50:39 GMT
Message-ID: <juOEf.2336$ZS3.1244@trndny05>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US