On 26 Apr, 16:32, EscVector <J..._at_webthere.com> wrote:
> 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.
Yup got it working - and it does what is needed - thanks everyone for
yur help!
Received on Thu May 03 2007 - 15:41:07 CDT
