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

I'm not sure I completely agree. I certainly don't react well to people suggesting the use of toys like Access and Excel. But were someone to suggest DB2/Universal Server I wouldn't have a problem. It isn't Oracle but it isn't amateur hour either.

Daniel A. Morgan

> I've got to agree with you TurkBear,
> Sometimes there's a near riot in this newsgroup when someone mentions anything
> 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
> mention that they're even THINKING about using something other than Oracle.
> 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 - 23:11:36 CST