Accessing oracle database through excel cell
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!
|