In article <8sigji$che$1_at_nnrp1.deja.com>,
jane_ballard_at_my-deja.com wrote:
> hello all,
>
> I have set up an odbc connection to the oracle database. I
> have tested it and it works. My question is how do I connect to the
> oracle database via odbc in excel.
>
> I know the odbc works because I could see the tables in
> access97. Any assistance is greatly appreciated.
>
> Best Regards,
>
> Jane
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Jane,
I haven't worked with Excel in a while but I have fetched data into
datasheets from Oracle tables. The code I recall using opened up a
recordset using DAO or ADO and then looped through it and inserted it
into Excel. You can find examples by searching MSDN
msdn.microsoft.com. Maybe there is an easier way but I do not think
so. My bet is it is going to require some programming. I just
remembered the other day I ran across a site with a tool called
oraexcel or somthing, I tried looking for it and could not find it,
maybe someone reading this will have a link.
--
Ethan
http://www.freetechnicaltraining.com/people_1.htm - Homepage
http://www.gnumetrics.com - Oracle Performance Monitor
http://www.qarbon.com - Create your own tutorials!
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Oct 18 2000 - 03:22:08 CDT
