Excel sharing data with access.

[Fuga]

Hi.

I´m posting this in the General forum since I´m not sure whether it´s an excel or an access question.

The data is stored in access, and I query it in access. Having done so, I wish to create a graph on it in excel (because there are more options for graphs).

Currently, I export a table (created by a query) and open it in excel. However, every day the data changes, so I have to do this every day.

I was wondering if you can link excel to an access table so I won´t have to export etc all the time.

As you may have quessed, I´m not very experienced in excel.

Fuga.

 

[simongallop]

The way to 'link' it is:

1/ Output the query as "MySource.xls"

2/ Open MySource.xls

3/ Open a new excel workbook and call it "MyGraph.xls"

4/ Create the graph in "MyGraph.xls" referencing the info in "MySource.xls"

Now you can output the query on a daily basis as "MySource.xls" and when you open MyGraph.xls it will show the correct data

HTH