Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query Parameters
I am trying to select data from an Oracle (external) table. I am using the
"Import Data" option. However, my "Parameter" button is not enabled (Grayed out). Any idea why or how to get it enabled? What I need to do is enable the query to pull in values based on the value in a cell. for example, with the following query: "SELECT EMP_DETAILS.DEPARTMENT_ID, EMP_DETAILS.LAST_NAME, EMP_DETAILS.SALARY" & Chr(13) & "" & Chr(10) & "FROM EMP_DETAILS EMP_DETAILS" & Chr(13) & "" & Chr(10) & "WHERE (EMP_DETAILS.LAST_NAME="MY_NAME)" - I am simply trying to replace "MY_NAME with the value that is in Sheet 3, cell B3. Any help you could give me is most appreciated. I am stumped! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query Parameters
check these:
http://nickhodge.co.uk/gui/datamenu/...taexamples.htm http://www.dicks-clicks.com/excel/Ex...htm#Parameters -- Regards, Tom Ogilvy "hll" wrote: I am trying to select data from an Oracle (external) table. I am using the "Import Data" option. However, my "Parameter" button is not enabled (Grayed out). Any idea why or how to get it enabled? What I need to do is enable the query to pull in values based on the value in a cell. for example, with the following query: "SELECT EMP_DETAILS.DEPARTMENT_ID, EMP_DETAILS.LAST_NAME, EMP_DETAILS.SALARY" & Chr(13) & "" & Chr(10) & "FROM EMP_DETAILS EMP_DETAILS" & Chr(13) & "" & Chr(10) & "WHERE (EMP_DETAILS.LAST_NAME="MY_NAME)" - I am simply trying to replace "MY_NAME with the value that is in Sheet 3, cell B3. Any help you could give me is most appreciated. I am stumped! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Query Parameters
This was really helpful and it got me 90% there. However, what I need to do
is do a join based on 2 parameters. Every example I find only has one parameter being repalced and whatever I try, it seemd to fail. Does anyone have anyone have a snippet that can show how to handle multiple parameters. For example: "select X from employee where name=? and age ?" Thanks again. "Tom Ogilvy" wrote: check these: http://nickhodge.co.uk/gui/datamenu/...taexamples.htm http://www.dicks-clicks.com/excel/Ex...htm#Parameters -- Regards, Tom Ogilvy "hll" wrote: I am trying to select data from an Oracle (external) table. I am using the "Import Data" option. However, my "Parameter" button is not enabled (Grayed out). Any idea why or how to get it enabled? What I need to do is enable the query to pull in values based on the value in a cell. for example, with the following query: "SELECT EMP_DETAILS.DEPARTMENT_ID, EMP_DETAILS.LAST_NAME, EMP_DETAILS.SALARY" & Chr(13) & "" & Chr(10) & "FROM EMP_DETAILS EMP_DETAILS" & Chr(13) & "" & Chr(10) & "WHERE (EMP_DETAILS.LAST_NAME="MY_NAME)" - I am simply trying to replace "MY_NAME with the value that is in Sheet 3, cell B3. Any help you could give me is most appreciated. I am stumped! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Query - 2 Parameters | Excel Discussion (Misc queries) | |||
Query parameters | Excel Programming | |||
Query Parameters | Excel Discussion (Misc queries) | |||
Web Query Parameters | Excel Programming | |||
Query Parameters | Excel Programming |