Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news-pusher.readnews.com!198.186.190.247.MISMATCH!news-out.readnews.com!news-xxxfer.readnews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!local01.nntp.dca.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail NNTP-Posting-Date: Thu, 02 Feb 2006 21:21:39 -0600 Reply-To: "Mark C. Stock" From: "Mark C. Stock" Newsgroups: comp.databases.oracle.server References: <1138874234.281839.224340@o13g2000cwo.googlegroups.com> <5b4d1196946f3@uwe> Subject: Re: oracle output to excel Date: Thu, 2 Feb 2006 22:21:36 -0500 Organization: Enquery, Incorporated X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original Message-ID: Lines: 28 NNTP-Posting-Host: 68.57.99.188 X-Trace: sv3-HidRiPqKYKUefYDVsVh0Y782VD1HWClhdQziHXpZcgW7yjdrPjfTRTfJCK85mfH9gAuoxYy8eXOY7ve!RpfWFvxg/yBpRJND0zc4vcY6kI8rD9J/3w1yjJ8JrUhY8xtheyNDj9Lh/udQb9W5FHaGhrDuUPco!jQ== X-Complaints-To: abuse@comcast.net X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.32 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:260630 "Database r via DBMonster.com" wrote in message news:5b4d1196946f3@uwe... > If your tables are not that big, then with spool create text file > delimited > (kind of csv) and then open it with excel. > You can make a script that will spool data on the daily basis > > If tables contain a lot of data, then spooling can significantly slowdown > database. You can try using some third party high-speed products like > fastreader to extract data into csv : www.wisdomforce.com > > 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 > > -- > Message posted via http://www.dbmonster.com has anybody mentioned DBMS_JOB and UTL_SMTP yet? the OP did specify scheduling and emailing, not just file format ++ mcs