Re: sending oracle report to file
From: Gerrit-Jan Linker <linker_at_oraxcel.com>
Date: Wed, 5 Apr 2000 16:25:03 +0100
Message-ID: <8cfqm3$dsr$1_at_newsg4.svr.pol.co.uk>
Date: Wed, 5 Apr 2000 16:25:03 +0100
Message-ID: <8cfqm3$dsr$1_at_newsg4.svr.pol.co.uk>
If it is easier to just get the data straight into Excel consider using Oraxcel. Oraxcel willjust take the SQL and fetch the data into Excel.
Regards,
-- Gerrit-Jan Linker web: http://www.oraxcel.com email: gjlinker_at_oraxcel.com Oraxcel: Linking Oracle to Excel OraCodes: Explaining ORA- error codes OraSQL: Explaining Oracle SQL syntax OraDebug: PL/SQL debugger OraWeb: Oracle access from IE Bo Seiffert <fox61_at_hotmail.com> wrote in message news:8cevi5$8i0$1_at_nnrp1.deja.com...Received on Wed Apr 05 2000 - 17:25:03 CEST
> To manipulate in Excel you would need an ASCII file.
> Try setting up a local printer on the Windows client. Manufactor and
> model should be Generic and Generic/Text Only.
> When running the report put Destination (DESTYPE) as File and Format
> (DESFORMAT) should equal (100%) the Windows name of the printer just
> created. In DESNAME you give the path and full filename of the output
> file.
> In this way you will get an reasonably well formatted ASCII file to
> import to Excel.
>
> In article <38EA4F39.813D8F5C_at_emirates.net.ae>,
> ombaf_at_emirates.net.ae wrote:
> > Hi all !
> >
> > I am trying to send a report from developer to a file so I can
> > manipulate the figures in excel. I seem to get garbage in the file.
> Am I
> > overlooking something ?
> --
> Bo Seiffert
> Somewhere in Denmark
> Even if you are on track, you will get run over if you just sit there
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.