What is the actual Expression used in the Excel Connection Manager? The screen shots in your original article are too blury to read, and your followup post simply left it...

What is the actual Expression used in the Excel Connection Manager? The screen shots in your original article are too blury to read, and your followup post simply left it...

Thanks Jeff and David!

Thanks, Matt. I'm testing it right now.

Thanks, Jeff. I'm green enough that I'm now googling "Dynamic SQL."

Thanks for your help!

I'm getting the same error with this syntax:

Select

@ListNo, BulkColumn from Openrowset(