I create hidden spreadsheet in a workbook with a macro that automatically starts when the workbook is opened and creates a new workbook, populates it with the data and closes the original workbork leaving the data behind. The user can then choose what they do with the results.

The code is standard apart from the connection string and the stored procedure used. It creates the headings from the sql column names and the data type to determine data format.