How to Use SQL Statements in MS Excel. ... Open Microsoft Excel and then create a new workbook file or open an existing file to which you want to connect an external data source.

I would like the user to be able to click a button on the web page that will run a SQL query (canned report) and export the result data to an Excel spreadsheet. The data does not need to display ...