Too few parameters. Expected 1 Error

[MitchPitt]

I want to import a query from access into excel, and I keep getting the error "Too few parameters. Expected 1". The thing I don't understand is the query will run flawlessly in access, but for some reason does not work when wanting to import it into Excel. Suggestions?

 

[PHV]

No parameter in your query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[MitchPitt]

There are no parameters. I don't understand how it works in Access, but not in Excel

 

[PHV]

Any chance you could post the SQL code of your query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[MitchPitt]

I have been looking at my queries, I think I may have some small issues in some of the queries. The final query relies on layers of different queries. I will let you know if I get anywhere with it.

 

[MitchPitt]

Figured it out, apparently Excel doesn't like sql queries with static fields placed in the query on the fly (ex. "hello" as Message).

 

[PHV]

static fields placed in the query on the fly
???