Exporting to Excel ?

[Kerstin]

I would like to import a query into an excel spreadsheet -
BUT I want the excel spreadsheet to automatically update
when the Access query changes.

Is that possible?

So far I was able to export the access data into a new
excel spreadsheet but it would not automatically update.

 

[Arni Laugdal]

Dear Kerstin,
Try the other way. Go to Excel and select:
Data
Import External Data
New Database Query
Select MS Access from Databases Click OK
Select the database Click OK
Select the Query and Columns in the query
and the rest will explain it self...

Then can you always right click the data in Excel and
select update to get latest data from Access. This is only
one way connection dataflow: Access to Excel not Excel to
Access.

Enjoy,
Arni Laugdal,
Master Instructor
www.til.is\msaccess