Från SQL Server till Excel
QUERY in data till Excel
You can use Microsoft Query to retrieve data from external sources, you don't have to retype the query and you can use Excel cells to filter the data from the database.
To import external data into Excel with Microsoft Query, follow the steps below.
On the DATA tab, click From Other Sources and then click From Microsoft Query.
On the DATA tab in Excel, click From Other Sources and then click From Microsoft Query.
Specify a data source for a database, text file or Excel workbook.
Specify a data source for a database, text file or Excel workbook.
Follow the steps below to create a new data source.
Follow the steps below to create a new data source.
Create a new SQL Server login.
Once you have configured the database server options, you need to select the table where you will get the data. The query wizard helps to create a simple SQL query to retrieve all data from that table. After finishing the query wizard you will select the option to edit the query in Microsoft Query.
The query wizard helps to create a simple SQL query to retrieve all data from that table
Query Wizard - Filter Data in Microsoft Excel
Query Wizard - Sort Order in Microsoft Excel
Query Wizard - Finsih interface in Microsoft Excel
The window after those steps is similar to the MS Access Query Wizard. In the previous steps we didn't choose to filter data and now you will change the SQL statement typing the WHERE clause with "?" as the parameter value.
Microsoft Query interface with the query and data
Above you defined which field or fields will work to filter your data. Now choose how the parameter value is obtained and in this case you select to get the value from the following cell.
Choose how the parameter value is obtained in Microsoft Excel
With two parameters in this example, the cells for the date can be seen below and after changing the value you will get different results.
Two parameters in Microsoft Excel
Data updates in Microsoft Excel as the parameters are updated
Conclusion
Instead retrieving the entire dataset from the table and then filtering in Excel, you can use filters to retrieve only the necessary data using a SQL query.

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.