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: spool an Excel file

Re: spool an Excel file

From: Norbert Vossiek <norbert.vossiek_at_gmx.li>
Date: Fri, 17 May 2002 13:06:33 +0200
Message-ID: <ac2ofe$48k$00$1@news.t-online.com>


Try to import them from Excel via ODBC.

"bb" <b_map_at_hotmail.com> schrieb im Newsbeitrag news:4a6ed956.0205170217.36630db3_at_posting.google.com...
> 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) Received on Fri May 17 2002 - 06:06:33 CDT

Original text of this message

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