I need to create a button in Excel that when clicked will query an
Oracle database using a value stored in cell E1 as a restriction in the
query. Also I need the results of the query to be listed in a range of
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 query
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 names
from the oracle db to be populated in cells IT4 - It 300.

Thanks,
Dan


------------------------------------------------
~~ 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