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