Re: Oracle DDE Manager and Excel

klukes_at_novatel.ca (Kevin Lukes) writes:

>I thought I'd resurrect a product that's been gathering dust on our
>shelves titled "Oracle for Windows DDE Manager" and use it to interface
>to some Excel spreadsheets dependent on data residing on a remote
>database.
 

>It sets up fine - I'm able to create a remote reference in a cell and
>extract data as expected. Problem is, I can't figure out the syntax
>(if there is any) to make the query dependent on an Excel cell reference.
 

> i.e. something along the lines of:
> select description from parts where partno = $A$1
 

>The manual very carefully avoids this subject, its examples relying on
>canned queries or values "hard-coded" into the query itself. This seems
>like such an incredibly useful thing to be able to do, I would have thought
>the manual would at least make reference to whether its possible or not.
 

>Has anyone had any experience with this product who can confirm whether
>such a feat can be accomplished? Otherwise, I suspect the box will be
>going back on the shelf and serve as nesting material for the vermin.
 

>===========================================================================
>Kevin J. Lukes Programmer/Analyst | klukes_at_novatel.ca
>NovAtel Communications Ltd. | (403)295-4573
>Calgary, Alberta CANADA | "Opinions expressed are my own"
>===========================================================================

We tried the same thing. No go. Asked Oracle. No solution.

We put the box back up on the shelf. But not until after wasting 3-4 days trying to make it work...

Regards,

-- 
* Carsten Kristensen		      E-mail: ckr_at_ocsbrg.no 	*
* Offshore Computer Services AS       Tel   : +47 55 99 88 70	*
* Bergen, Norway		      Fax   : +47 55 99 88 84	*
* select std_disclaimer from opinions_not_shared_by_employer;   *