Exporting file from Acess to Excel (1 Viewer)

[umair434]

Hi,

I want to import a query from Access 2007 to Excel 2007. This query is regularly updated, so I want to see the changes in the excel worksheet as well - Basically, everytime I run the query the excel worksheet should also get updated.


anyone knows how to work this around?

thanks

 

[lemo]

so basically you want your excel file to be automatically updated when you open it?

if so, just go to data->connections->properties (before clicking on 'properties', select that specific connection of yours, there may be more than one), then just check 'refresh data when opening the file'. that should do it, i think..

l