How to query ORACLE from EXCEL ? ? ? ? ?

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 Received on Fri Oct 11 1996 - 00:00:00 CEST