Re: excel odbc to oracle request

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:39ed7775_at_news.iprimus.com.au...
> Hi Jane,
>
> Funny you should ask -I've just had to do this for myself. Not sure if
 it's
> what you're after, and I'm not sure whether it would be the same for any
> version of Excel other than Excel 2000, but all I did was click [Data]
 [Get
> External Data] [New Database Query].
>
> That invokes Microsoft Query, and at that point, I chose from the list of
> possible sources the name of the ODBC source previously created using the
> Control Panel applet (which was pointing at my Oracle database). Time to
> make a nice cup of coffee, a soufflé or two and a small roast dinner, and
 by
> the time I was just finishing off the plum pudding, the connection to the
> database had been made, and Lo! There was SCOTT.EMP available for
 selection
> (along with everything else too).
>
> After that, it was all pretty plain sailing (apart from the repeated
> crashes. God, I love Microsoft products).

Works at least as far back as office95.

If you want impressive you can also create an XL pivot table direct from an Oracle data source. This has one other added advantage

XL has a limit to the number of rows a sheet can contain. This will cause problems (including crashes) if your query returns more than that number of rows. An XL pivot table appears to be limited only by available memory.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

(and MCP but don't tell anyone will you).