How to add parameters to an external data query in Excel which can’t be displayed graphically?
Excel’s interface for SQL Server queries will not let you have a custom parameters. A way around this is to create a generic Microsoft Query, then add parameters, then paste your parametorized query in the connection’s properties. Here are the detailed steps for Excel 2010: Open Excel Goto Data tab From the From Other Sources button choose … Read more