Re: newbie: how to get oracle data into Excel or Access

I've got to agree with you TurkBear,
[Quoted] [Quoted] Sometimes there's a near riot in this newsgroup when someone mentions anything [Quoted] other than Oracle (ever seen the threads comparing Oracle to SQLServer?). I"m not referring in the least to Dan's posting in this thread by the way.

It's just that sometimes posters seem to take their life in their hands if they [Quoted] mention that they're even THINKING about using something other than Oracle. [Quoted] Larry must be smiling all the way to the bank.

Steve

TurkBear wrote:

> Well, he could be trying to do statistical stuff that Oracle can't handle (
> median, for instance) of he may prefer Excel's graphing capabilities, or he may
> prefer to use Excel's much superior cross-tab functions...
> Not everything is a nail so a hammer isn't enough of a tool set...
>
> "Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote:
>
> >I agree. But one might also ask what he thinks he is going to do in Excel or
> >Acces he couldn't do better and faster in Oracle in the first place?
> >
> >Developing Excel and Access skills will barely keep you employed these days.
> >Developing Oracle skills pays the mortgage.
> >
> >Daniel A. Morgan
> >
> >
> >
> >> My ODBC to Excel is very fast.
> >> You could use SQL*Plus to write a Comma Separated Value file and then
> >> import that into Excel. ( I think Excel will do that)
> >>
> >> For C++ look into OCI. Oracle Call Interface.
> >> http://rfhs8012.fh-regensburg.de/~oracle/proc/ch2.html
> >>
> >> Mike
> >>
> >> andrew queisser <andrew_queisser_at_hp.com> wrote in message
> >> news:99b60g$k03$1_at_hpcvnews.cv.hp.com...
> >> > I've got an ODBC connection to an Oracle database but it seems incredibly
> >> > slow. I also have something called SQL+ that installed itself when I put
> >> > Oracle drivers on my machine. Finally, I installed OO4O because I was
> >> > playing
> >> > with something called Oraxcel that links Excel to Oracle.
> >> >
> >> > My question: is there a good way of pulling Oracle data into Excel other
> >> > than
> >> > using ODBC? How about other MS apps such as MS Access?
> >> >
> >> > Finally, if I was going to write some simple C++ programs that query the
> >> > Oracle
> >> > database what would I use for that?
> >> >
> >> > Thanks,
> >> > Andrew
> >> >
> >> >
> >> >
  Received on Fri Mar 23 2001 - 13:46:48 CET