microsoft access training - Access links

I think perhaps Lucy meant the other way - such that if you have an Access database which feeds information into a spreadsheet, can you have it set such that when you update the database, it can refresh the spreadsheet?

Is this somethign that can be done by outputting the table/query to an excel spreadsheet, and overwriting the pre-existing spreadsheet each time or is there another way?

If it can be done by macro, then if you want it such that it'll happen when you open the database, name the macro AutoExec and it'll run it whenever you open your database.

Thanks

Ricardo