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 ...

You can directly run SQL queries on a database from Excel. The traditional method was to create a Macro and write a long Visual Basic code by using ADO connection to get connected with the source.

Start Excel and open a new or existing spreadsheet. Go to the "Data" tab and click on "From Other Sources" in the Get External Data group. Choose "From Microsoft Query" in the drop-down list.

Figure A Load the Excel data into Power Query. The first step is to load the data into Power Query as follows: 1. Click anywhere inside the Table. 2. Click the Data tab. 3.

Image: Renan/Adobe Stock Updating data in a Microsoft Excel workbook is common, but you will run into cases where you can replace manual input by running a bit of M code in Power Query. This task ...