Importing from Access

G

Guest

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
 
G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import Data from Access 1
Access Subscript out of range when importing into access 2010 from excel 0
No Results returned from Access query 3
Access #Error & Excel Pivot 0
Export to Access, Workbook Treated as a Query Response 1
Import External Data 3
Import Data from Access query 8
Problem importing from access 1

Top