Exporting to Existing Excel Worksheet from Access
I have existing Excel workbook containing numerous wkshts and charts. I want to be able to update the existing worksheets with a different Access datasource. This way I do not have to create duplicate charts. The reasons for the different datasource is I Need to display data for "All" selection that summarizes the data and 1 that is based on the selection criteria which is summarized differently. The Column numbers do not change just the rows.
Is there a way to export from Access to Excel with named ranges or to a specified worksheet.