Forum Discussion
Can you filter SQL data before importing to Excel?
Afternoon all! I'm trying to import data from our SQL server to Excel, using the Get Data > From Database > From SQL Server Database button. The SQL server is the main back end of our company's ...
In general Query folding - Power Query | Microsoft Learn shall work. Alternatively you may use SQL statement quiring the database.
Just don't load result into the grid before you finalized your query.
Thanks Sergei, that certainly looks like it would work. I'll try that when I'm back in the office and can access the server!