LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get data from Oracle Database to Excel? David Willis New Users to Excel 1 March 31st 06 01:57 PM
resetting last cell jagdish.eashwar Excel Discussion (Misc queries) 11 March 31st 06 02:06 AM
Can I copy a table from Word into one cell in Excel without losing data? (Office 97) [email protected] Excel Discussion (Misc queries) 2 November 29th 05 07:22 PM
Howto use excel cell value to lookup an oracle table Andre Excel Discussion (Misc queries) 0 April 5th 05 09:44 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 11:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"