Using Parameters in an external data query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For some reason, whenever I do an external data query, the Parameters
button/feture is ghosted and unavailable. Can someone explain why this might
be happening?
 
You need to set focus on the query area by putting your cursor on the cells
where the query is.
 
It really depends on the type of query, usually only the most basic queries
can be supported by parameters.
If your query is derived from views, or if youve got some complex
(relitively) case statements most of MSquery's GUI functions switch off.

This is a really anaoying problem, many times I am asked to change a report
because the user wants to see a different date range, or something like
that, so I have to physically change the original report and then you get
version control issues, whereas if the parameter function worked properly,
the user could make the changes.
 
Let me be more specific:

1) I use Data>Import External Date>New Database Query

2) I then brows to an Access data base, select the table and fields I want,
complete the wizard and return the data to a sheet in Excel.

3) The data is correct and updates correctly but the parameter button is
ghosted. I realize you have to have a cell selected within the data range
and and I do.

Any ideas?
 
Back
Top