Automate exportation and graph creation?

[pat_nospam]

Is there a method in which data can be exported by a button click from Access to Excel and then Excel to automatically create a graph (perhaps by Macros?).

Just wondering what other solutions people have implemented since the graphing system in Access is.. lacking.

TIA

Pat

 

[Mitch_____W]

You could put an excel sheet on a Report and have the excel sheet get it's data from the Access Table... I have played around with the whole moving data back and forth between Excel and Access before and realized that there isn't much you can do in Excel that you can't do in Access...

The charting in Access is pretty much the same as in Excel anyway...


Good Luck!

 

[Mitch_____W]

You could put an excel sheet on a Report and have the excel sheet get it's data from the Access Table... I have played around with the whole moving data back and forth between Excel and Access before and realized that there isn't much you can do in Excel that you can't do in Access...

The charting in Access is pretty much the same as in Excel anyway...


Good Luck!