I was not able to reproduce the exact problem you are facing with creating dynamic SQL query parameters in this way (for some reason the ... ... <看更多>

A user parameter is a single value, fixed when you press the run button. Instead, you need to use an attribute value. So you read the Excel file ... ... <看更多>

When a user invokes a function in Excel, optional parameters appear in brackets. In the following sample, the add function can optionally add a third number ... ... <看更多>

Hi there, This is my first post so appologies if it's in the wrong forum. I have an MS Query that downloads data from a SQL server. ... <看更多>