| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Importing external data with cell value as input parameter
Hi ,
I need a query database with excel value say as A1 as input parameter and return the query value in cell B1.Tried with Data--Connections.The connection DB is oracle and the excel verion is 2007.How can i pass the cell value to SQL statement? Thanks, PADS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get External Data from Access Parameter Query | Excel Discussion (Misc queries) | |||
| Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value also display in a selected cell on a worksheet | Excel Discussion (Misc queries) | |||
| how to pass a cell as parameter for an external program? | Excel Discussion (Misc queries) | |||
| Pull parameter from worksheet for External Data Query to SQL Datab | Excel Discussion (Misc queries) | |||
| Parameter/Criteria option not available for External Data Query | Excel Discussion (Misc queries) | |||
Hybrid Mode
