Re: newbie: how to get oracle data into Excel or Access
Date: Thu, 22 Mar 2001 01:56:24 GMT
Message-ID: <cZcu6.56825$zV3.4772314_at_news1.frmt1.sfba.home.com>
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 - 02:56:24 CET