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

I do. But this may relate to the fact that I don't spend much time in Windows. But speed is beside the point. What can you do in Access that you can't do better, faster, and with more bang on your resume' in Oracle in the first place?

Daniel A. Morgan

> 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 Fri Mar 23 2001 - 07:40:45 CET