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

I don't find ODBC from Excel to Oracle all that slow. If you have set up your SQL script (macro) to match you database indexes etc. (like any good SQL programmer or DBA will tell you), it works OK.

Ted

On Wed, 21 Mar 2001 21:00:14 -0800, "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
>> >
>> >
>> >
>

EMail: knijff_at_bigfoot.com Received on Thu Mar 22 2001 - 01:15:45 CST