Dashboard Creation Access to Excel

[Slicemahn]

Hi,
I am looking to populate worksheets in Excel with data from Access query. There are several sheets that need to be populated and each sheet has a layout with month column headers in a vertical direction and metrics in the horizontal direction. Any suggestions on how I can do a refresh and populate all sheets?

[mrojas]

I would create a table, or tables, with fields matching the column header on your Excel worksheet. From Excel, go to the Data tab (I'm assuming you're using Excel 2007) click on the "From Access" icon under the "Get External Data" icon. Follow on-screen instructions.
As with everything else in life, there are advantages and disadvantages to this.
This will not work if you distribute your application unless you also distribute the Excel files. This will not work either if the database is moved from one folder to another.
As for advantages, the data viewed in Excel will always be the latest as it would be "linked" to the data source.