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

Use TOAD

Ted Knijff <knijff_at_bigfoot.com> wrote in message news:3ab9a693.3627095_at_news.online.de...
> 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 - 17:13:58 CET