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

I didn't intend it as a equi-join with "holier than ...." I thought the meaning, at least in this group, would be clear. Everyone knows Excel and Access. Heck my mother knows them well enough to use them on the job and she's almost 80. They are stand-alone products one of which occasionally masquerades as a multi-user database. But they are hardly Oracle, they are hardly DB2/Universal Server, they are hardly Informix, and they are hardly secure, scalable, or robust.

I would not use the word "toys" in a Microsoft of general forum. But in the context or these forums I would have thought the meaning clear. My apology if that was not the case.

Daniel A. Morgan

Ted Knijff wrote:

> 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 - 09:02:09 CST