View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
coeus coeus is offline
external usenet poster
 
Posts: 7
Default 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!