Re: How to query ORACLE from EXCEL ? ? ? ? ?

In Article<325dfcaf.3208462_at_news.airmail.net>, <alchase_at_airmail.net> writes:
> Path: rocksanne!parc!nntp-hub.barrnet.net!informix.com!informix.com!news.na.informix.com!cam-news-feed3.bbnplanet.com!cam-news-hub1.bbnplanet.com!www.nntp.primenet.com!nntp.primenet.com!feed1.news.erols.com!uunet!in1.uu.net!news-in.iadfw.net!usenet
> From: alchase_at_airmail.net (Al Chase)
> Newsgroups: comp.databases.oracle
> Subject: How to query ORACLE from EXCEL ? ? ? ? ?
> Date: Fri, 11 Oct 1996 08:05:38 GMT
> Organization: INTERNET AMERICA
> Lines: 37
> Message-ID: <325dfcaf.3208462_at_news.airmail.net>
> NNTP-Posting-Host: finance3.iadfw.net
> X-Newsreader: Forte Agent .99e/32.227
>
>
>
> EXCEL has an interface requiring ODBC for doing queries of an ORACLE
> database
>
> the syntax listed in the EXCEL help notes are
>
> SQL.REQUEST(connection_string, output_ref,drvier_prompt,
> query_text, col_names_logical)
>
> The notes go on to describe the connection_string as
>
> DNS = My Oracle Data Source;DBQ =MYSERV VER;UID=JohnS;PWD=Sesame
>
> I use my ORACLE host string for the DNS and my username and password
> for UID & PWD, and have tried a variety of things for the DBQ, but I
> get the #NAME? error every time.
>
> The EXCEL help notes also say:
>
> If SQL.REQUEST is unable to access the data source using
> connection_string, it returns the #N/A error value.
>
> Evidently I am not even getting that far.
>
> I have tried both with & without having opened a SQL connection;
>
> How can I get to work?
>
> Thanks in advance
>
> Al
> alchase_at_airmail.net
>
>
>
>

Why don't you simply click on Pivot table in data menu in excel. It will execute MS query for you and you can add the oracle table there and do your operations. Record the macro and make necessary modifications.

Good Luck!

Amit
atyagi_at_mc.xerox.com Received on Wed Oct 16 1996 - 00:00:00 CEST