Import from Access/ Export from Excel

[papadega3000]

I have a chart to build using data from my Access Database. Most of the data is coming from one table but I am having a hard time finding a way to build a chart in Access. So my thought was to import data from the Access DB and send it to Excel that way I could format the data into columns and create a bar graph.

I am not very familair with technique I know it can be done but I am looking for a how to guide/tutorial that could possibly explain it to me. Or if someone has knowledge of how this can be achieved. I would appreciate any advice you can give. I assumed the easiest way to accomplish this task would be to use VBA to make the connections.

My other question would be can I export the graph I make in Excel and bring it back in Access or would it be better to just have a DoCmd to open the Excel Chart in Excel?

Thanks in Advance.

 

[boblarson]

You don't have to move the data out of Access to use Excel. You can link to the data within Excel. To start, in Excel go to DATA > Get External Data > New Database Query and follow the wizard to link to the data.

Then, you can create your charts based on the data in the one spreadsheet.

You can also set the Excel sheet (and therefore charts) to auto update. To do so, go to DATA > Get External Data > Data Range Properties and check the check box Refresh Data on File Open.

 

[papadega3000]

Thanks for these instructions... it doesn't seem that bad to do... I will give it a shot on Monday when I am back in the office.

I will keep you posted.. because I am sure I will have some more questions.