D
DM - NPS
I have 2 queries in Access and I want to import the data from those queries
into an Excel file (called Charts.xls). Each query and related chart will be
on a different worksheet of the Excel Workbook.
I tries using the do.cmd OutputTo option (tied to a command button) which
allowed me to transfer the data to Excel but when I run the command it
deletes the Chart already setup in the Excel file.
As an end result what I want is for a person to click the command button and
it opens the excel file and displays the most up-to-date data and a bar char
associated to the data.
Any Ideas? Thanks in for the help.
into an Excel file (called Charts.xls). Each query and related chart will be
on a different worksheet of the Excel Workbook.
I tries using the do.cmd OutputTo option (tied to a command button) which
allowed me to transfer the data to Excel but when I run the command it
deletes the Chart already setup in the Excel file.
As an end result what I want is for a person to click the command button and
it opens the excel file and displays the most up-to-date data and a bar char
associated to the data.
Any Ideas? Thanks in for the help.