Unfortunately, I can't seem to figure out how to call on values from Excel
cells to insert into the queries written in the Query Wizard.

"CLR" wrote:

You can do Data GetExternalData CreateNewQuery and follow the menus.
You must however, have specific access and Rights to the database or it won't
work.

hth
Vaya con Dios,
Chuck, CABGx3



"coeus" wrote:

Hi,
The problem I am trying to solve is acessing an oracle database and excecute
a query through an excel cell.

The query would be as follows: select count(XXX_ID) from XXX.YYY_YYY where
AAA in (Excel cell B2) and CCC in (Excel cell G2);

Is is possible to execute such a query, and capture variable info from
another excel cell?

Thanks for any help!