Excel - MS Query - Parameter Query

[SkipVought]

I can specify a criteria for is one of which generates an IN Clause in the SQL.

I want to make this a Parameter Query based on a List.

I cannot seem to format a valid list in the parameter box. Can you?

Skip,
[sub]
[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM! [/sub]

 

[SkipVought]

bump

Skip,
[sub]
[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM! [/sub]

 

[dca]

Did you ever figure out how to do this? I am currently trying to do the same thing. I have performance data for all of the systems I administer in a sql server database. I linked the IN clause parameter field to a cell where I would like to list multiple systems and have the data returned for multiple systems. Right now it only works with one system.

 

[SkipVought]

dca,

I gave up using a pure parameter query. I gen a list and stuff it in my SQL string using VBA.

Skip,
[sub]
[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM! [/sub]