Use a DSN-less connection (i.e. with no data source defined on the server) to connect the program to your database for simplicity. You will need to use HTML to format the data.

Read on for a guide to using Excel’s dataviz tools to present your data. We use the Office 365 version of Excel for Windows in the descriptions below; some features may not be available if you ...