Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus and excel - beginners question!
On 25 Apr, 22:52, Rene Nyffenegger <rene.nyffeneg..._at_gmx.ch> wrote:
> On 2007-04-25, 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?
>
> If you're not bound to using SQL*Plus, maybe the following link
> helps:http://www.adp-gmbh.ch/blog/2007/02/01.php
>
> Regards, RenÚ
>
> --
> Rene Nyffenegger
> http://www.adp-gmbh.ch
Always great advice from this list!
I cut and pasted the code into the Visual basic editor made a
reference to ActiveX
And now I get a run time error.
"Oracle client and netorking components were not found"
Actually I only have the Oracle Instant client installed - sqlplus
works from the comand line.
Do I maybe need the Full Client?
Received on Thu Apr 26 2007 - 08:46:49 CDT