Now that we’ve written a simple SQL query in Excel, let’s create a Macro that will print the entire table from the database into the Excel sheet. To do this, press Alt+ F11 to start the Visual ...

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.