MS Query 'Invalid pseudocolum "$D$5"

[Guest]

I am trying to use a cell in my spread sheet as a parameter in MS Query.
(Select data from table where field = "value in Excel cell".)

Does anyone know the proper syntax to do so. I get an invalid pseudocolumn
error so I am thinking there must be a 'valid' pseudocolum method.

Thanks.

 

[NickHK]

When you create you query in MSQuery, after building the SQL, change the
desired value to ?

Then when you return to Excel, right-click on the query and you the
Parameters option will be available.
Enter info there as required.

NickHK

 

[Guest]

I've tried the ? thing and am told that "parameters are not allowed in
queries that are too complex to be graphically displayed". :-(

 

[NickHK]

I guess you have reached the limitations of MSQuery and should changed
something like ADO.

NickHK