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

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 21 Mar 2001 21:00:14 -0800
Message-ID: <3AB986DE.CCF40ABB_at_exesolutions.com>


[Quoted] [Quoted] I agree. But one might also ask what he thinks he is going to do in Excel or [Quoted] [Quoted] Acces he couldn't do better and faster in Oracle in the first place?

[Quoted] [Quoted] Developing Excel and Access skills will barely keep you employed these days. [Quoted] 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 Thu Mar 22 2001 - 06:00:14 CET

Original text of this message