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

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 Thu Mar 22 2001 - 14:29:46 CST