Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Data from Oracle to Excel | Excel Discussion (Misc queries) | |||
Exporting Data from Oracle 11i to XL 2007 (TSV) | Excel Discussion (Misc queries) | |||
Imported Oracle Data | Excel Discussion (Misc queries) | |||
Loading data from Excel to Oracle | New Users to Excel | |||
Oracle data to excel | Excel Programming |