Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus and excel - beginners question!
On Apr 25, 1:15 pm, ton de w <ton_de_win..._at_yahoo.co.uk> wrote:
> Hello,
> I am querying a table in Ora9i. It does have 100 + fields. I am
> invoking sqlplus from a windows cmd box. This is temporary until toad
> is installed. Have to make do with sqlplus/cmd window fro the moment.
> So when I do a select * from table the output is unreadable. I can,
> and do, redirect this to a file.
> Can I redirect the output to, say, output.xls and then open this file
> in excel - and have column heading and the field values underneath?
>
> TIA
>
> Ton
You could do either of the previous suggestions or you could simply configure an ODBC connection to the database, open excel, and >import external data > new database query....
In general I hate ODBC, but it might be the simply solution here. Received on Thu Apr 26 2007 - 10:30:31 CDT