View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Accessing oracle database through excel cell

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!