Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: newbie: how to get oracle data into Excel or Access

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

From: Ted Knijff <knijff_at_bigfoot.com>
Date: Sat, 24 Mar 2001 14:29:29 GMT
Message-ID: <3abcadee.5074937@news.online.de>

Daniel, that's a pretty hard statement, "toys..". Access and Excel (especially Excel) certainly have their uses and who cares where the data comes from when you have a spreadsheet to deliver, as long as it's accurate and reliable. Let's try to not be holier than the pope.

;-)

Ted

On Fri, 23 Mar 2001 21:11:36 -0800, "Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote:

>I'm not sure I completely agree. I certainly don't react well to people suggesting
>the use of toys like Access and Excel. But were someone to suggest DB2/Universal
>Server I wouldn't have a problem. It isn't Oracle but it isn't amateur hour either.
>
>Daniel A. Morgan
>
>
>
>
>> I've got to agree with you TurkBear,
>> Sometimes there's a near riot in this newsgroup when someone mentions anything
>> other than Oracle (ever seen the threads comparing Oracle to SQLServer?).
>> I"m not referring in the least to Dan's posting in this thread by the way.
>>
>> It's just that sometimes posters seem to take their life in their hands if they
>> mention that they're even THINKING about using something other than Oracle.
>> Larry must be smiling all the way to the bank.
>>
>> Steve
>>
>> TurkBear wrote:
>>
>> > 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
>> > >> >
>> > >> >
>> > >> >
>

EMail: knijff_at_bigfoot.com Received on Sat Mar 24 2001 - 08:29:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US