ACCESS to EXCEL - automate query to fill spreadsheet
Posted on 2009-02-23
We have an ACCESS db but clients would find it easier to prepare the graphical reports (charts) in Excel. Currently we assist the user by running a make-table query to select ACCESS data and then exporting this table into Excel. Looking for a simple process to automate the process of running the query, exporting the data, and filling the Excel sheet with Access data for users unfamiliar with data structures, queries, etc.
Is it possible to automate a process as follows: when the user opens a pre-defined Excel sheet, it runs a query in ACCESS that brings back data to fill a new page in the Excel workbook.
Thanks for your assistance.