Re: spool excel file with sql*plus

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 17 May 2002 19:50:53 GMT
Message-ID: <3CE55F17.D3E7C210_at_exesolutions.com>


Mike Alba wrote:

> How about using Oracle forms?
> Or if you want to get more fancy
> www.oraxcel.com
>
> bb wrote:
>
> > Is there any posibility to make a spool file in the right format for
> > Excel?
> > Just from sql*plus. So i open a dos-batch file which opens sqlplus and
> > runs a statement like 'select * from dual' and i'll wil get an .xls
> > file on my C: which contains an 'X'
> > I really need a real excel formatted file, which does not have to been
> > imported in excel. I.e. from TOAD you can save directly to an Excel
> > file. This is what i wanna do in a batch without using TOAD. (So, no .csv file)
> >

[Quoted] [Quoted] I would still like someone to tell me what they are doing with Oracle data in Excel [Quoted] that they couldn't do better in Oracle. Except, perhaps, cook the numbers.

Daniel Morgan Received on Fri May 17 2002 - 21:50:53 CEST

Original text of this message