MS Query 'Invalid pseudocolum "$D$5"
 

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.

MS Query 'Invalid pseudocolum "$D$5"
 

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

"Johnslg" wrote in message
...
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.

MS Query 'Invalid pseudocolum "$D$5"
 

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

"NickHK" wrote:

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

"Johnslg" wrote in message
...
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.

MS Query 'Invalid pseudocolum "$D$5"
 

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

NickHK

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

"NickHK" wrote:

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

"Johnslg" wrote in message
...
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.