MS Query: Too few parameters 1

[Gavona]

I am using excel 2010 (and I have PowerQuery installed but not used in this workbook).
The source data is a table in another workbook.
The message I get is "Too few parameters. Expected 3." Why would it expect 3? How do I best resolve this, please?

The SQL is:
SELECT `Data$ExternalData_1`.`Cost Center`, [deleted rest of Select]
FROM `Data$ExternalData_1` `Data$ExternalData_1`
WHERE (`Data$ExternalData_1`.`UserID Combined` Like ?) AND (`Data$ExternalData_1`.`LA01#LA01_1` Like ?)

If from MS Query I try to return the data to Excel I get prompted for two parameters which is what I would expect and then I get the error message.

The connection Properties are set to get the parameters from specific cells in the workbook

Gavin

 

[SkipVought]

Hi,

This error message occurs when there are any fields that the MS Query Manager cannot resolve. So one of your Field Names or Table Name is incorrect, perhaps there’s a leading or trailing space missing.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Gavona]

That makes total sense, I have been tweaking the source data, thanks Skip. My internet searching didn't turn up that simple fact



Gavin

 

[Andrzejek]

Are you using an alias for a table with the same name?
[tt]
FROM `Data$ExternalData_1` `Data$ExternalData_1`[/tt]


---- Andy

There is a great need for a sarcasm font.

 

[SkipVought]

Your SQL ought to look like this for the Like operator...

Where YourField Like ‘%’ & [?] & ‘%’

BTW, my iPad TIC marks (‘’) won’t actually work.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Gavona]

Thanks for the additional pointers - I'll have a play with both of your suggestions. I have it working - resolved by Skip's first response (which sort of explains my tardiness in coming back to the post!).

I think I can see what you are both getting at. I used MS Query to create the SQL. I will try tweaking it (and the table name) just so I learn a bit more about SQL. (Mind you, I have just got Power Query and that looks a better tool to focus my learning on than SQL )

Gavin