Import Data to Excel but Keep Chart Format

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.
 
G

Gina Whipp

DM-NPS,

I wouldn't try to send the chart but the data and then have the Excel
workbook open to the chart.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Exported Excel File is Incomplete 7
Import Excel 2010 table into Access 2010 - not listed as range 0
Why do charts disappear? 3
Reuse a Chart with new data 0
Bar Chart with Data Elements 1
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2

Top