Excel loop failure when extracting subset of rows

[Phil_Kelsey]

It appears 1 million blank rows somehow were added to my worksheet. I deleted them and appears to fix things. However, I switched to odbc and sql statements which seem to work well. However, I am trying to use named parameters (@param) in the “Run Query” activity, but I am only able to make ordinal position parameters with “?”. Can anyone confirm if named parameters are not valid for this type of connection?

I asked this question here

ODBC Excel as a database using named parameters

I am using an ODBC connection to Excel to be able to run sql queries. The “Run Query” activity has a dialog to create a list named parameters. I tried syntax of “@param” in the update dml statement but get a runtime error saying X parameters required. The only way I can get the query to work is if I use the ordinal position and replace “@param” with “?”. Can anyone confirm if name parameters simply not allowed in this situation?