You can also check the box that says Refresh automatically when cell value changes. You can link parameters to cells in Excel. Returning the query to Excel prompts the standard import dialog:Ĭlick properties, and then Definition and Parameters. The notation <= means that the value is a parameter, and the prompt for this parameter will be ToYear. In the criteria tab, you may define filters to query and can specify that the filter values will come from parameters. Once inside Microsoft Query, you can do a lot of SQL editing without getting into SQL syntax. Select a DSN, and then select a table, columns and sorting order until the Query Wizard asks if you want to further edit the query: Starting a query immediately hints at how old this UI is: In Excel 2016, MS-Query can be found in the data tab. In addition, it doesn’t use Power Query technology and it’s ugly.

Its main drawback is that it supports only ODBC drivers, which involves a very old infrastructure that was first released in 1992. Oddly enough, the oldest method of MS-Query is the easiest, and doesn’t require any use of VBA. The parameter values should come from cells in Excel, and the data should be refreshed automatically anytime the value of any parameter changes in the grid. The goal is to import data into Excel from an SQL table with some input parameters. By Dany Hoter, DataRails Solutions Architect Task definition

Excel query table cell value