Data in Access - Graphs in Excel

[tpearo]

I have a small database that I've created in Access for gathering some important engineering data. I want to be able to graph the data ~ or link to a graph in Excel. I need the graph to be updated when the data is updated in the Access database.
Is there a simple way to do this?

Anyones help is appreciated.

Tp

 

[dhookom]

You can link the Access into Excel. Check under the Data menu select for Import External Data... or similar. You may need to either manually refresh or create code to refresh the data.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]