Chart in Excel using data from access???

[AJ]

I am looking for any and all advice. I would like to design a line chart but
would like to use excel since the charting options seem much more robust then
access. Ideally what I would like to do is export data (or a table) to excel
and then have a separate graph somewhere on a users pc access that data to
create a graph. I would like them to always be able to "run " the same excel
graph but it point to the data that I export (which could chnage each time
they use the access database).

Does this make sense? Can it be done. I am a novice to all of this and am
learning as I go. Any help would be great. Thanks.

 

[Arvin Meyer [MVP]]

Using an Excel Range, it is easily done. The last argument of the
TransferSpreadsheet Method is a string named range:

DoCmd.TransferSpreadsheet [transfertype][, spreadsheettype], tablename,
filename[, hasfieldnames][, range]

Name a range in your Excel document, create that range large than you will
ever have data in it. Then using automation, delete the existing data and
use the TransferSpreadsheet Method to refill it with Access data. I usually
have a totals line at the end of the Excel range to use as datapoints for
the chart.