Importing from Access

R

Richard

When importing the results of a query from an Access Db into Excel, is the
query automatically refreshed, or does the query need to be run in Access
prior to the import into excel?

Thanks in advance for the answer
 
P

Paul Mugleston

When taking data from Access to Excel there are two ways:-

Analyze with MS Excel
A static version of the queries current results is sent to Excel
In Access - Run query > Tools > Office Links > Analyze with Excel

External data placed in Excel
Where Data from a query in this case is placed into Excel but is still
linked to its origianl source (allowing it to be refreshed)
In Excel - Data > Import External Data > Import data (then select database
then query)
Then right click on the data (in Excel) and select Refresh data.

Hope this helps!
 
Top