Open query results in Microsoft Excel
Easily open results from any query into Microsoft Excel.
Steps
- Connect to any database
- Run a SELECT statement or a stored procedure that returns a resultset. Display the results in grid
- Once the query is complete, click the right mouse button on the grid and select Open in MS Excel
- WinSQL will open the results in MS Excel.
IMPORTANT You must have Microsoft Excel installed on the machine. This works with any version of Excel greater than Excel 1997.