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

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 Wed Mar 21 2001 - 23:00:14 CST