Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: spool an Excel file
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