Retrieving data from Oracle
 

I need to create a button in Excel that when clicked will query a
Oracle database using a value stored in cell E1 as a restriction in th
query. Also I need the results of the query to be listed in a range o
cells in the workbook on the same sheet the button exists.

example:

If cell E1 = 10, then I need a button that when pressed runs a quer
across an Oracle database;

Select name, number
from Panel
where number = '10'

I'm expecting 30 to 200 names to be returned. I would like these name
from the oracle db to be populated in cells IT4 - It 300.

Thanks,
Da

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements