How do I automatically update an EXCEL list from ACCESS?

[rlsj]

I noticed EXCEL can automatically update a list from SharePoint services.

Is there a quick and easy way to update a list from an Access query?

Is it "better" to create the code in ACCESS and reference excel or to create the code in EXCEL and reference access?

My Software:
Microsoft Windows XP Professional Version 2002 w/Service Pack 2
Microsoft Office Professional Edition 2003
Access 2003 (11.5614.5703)
Excel 2003 (11.6113.703)

[Stang02GT]

You can link excel to access, and have your spread sheets be tables in access. Is this along the lines of what you are looking for?

If so you can do this by going to

File
Get External Data
Link Tables

[rlsj]

You can link excel to access, and have your spread sheets be tables in access. Is this along the lines of what you are looking for?

If so you can do this by going to

File
Get External Data
Link Tables

Thanks for replying..
The data is in Access tables, but the summary information will be in Excel. Currently, I run ACCESS queries and paste the results into Excel. I like the list feature because it allows a user to group by specific values, but also allows the user to "drill-down" to a single complete record for researching discrepancies. However, my spreadsheets contain a lot of formatting AND each refresh will change the number of rows in each list. The manual process takes a long time. In the future, I will automate this so I can click a button and the entire spreadsheet will be recreated with all the updated summary data and formatting. For now, I just want to refresh those lists without spending too much time reformatting the worksheets.