Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing from Access
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing from Access
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! -- Paul Mugleston Data Officer from the UK "Richard" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Access Queries | Links and Linking in Excel | |||
Importing access query | Excel Discussion (Misc queries) | |||
Importing to Excel from Access | New Users to Excel | |||
Importing from Access | Excel Worksheet Functions | |||
Importing from Access | Excel Discussion (Misc queries) |