Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Importing a table from Access query
What is the quickest and easiest way to do the above?
Thanks in advance. |
#2
|
|||
|
|||
Hi
The way I usually do this is run the select query, click on the top-right box (which selects all records) and use Ctrl+C to copy and Ctrl+V to paste into my workbook. An alternative is to right-click on the query in the Database Window and left-click on Export. In the Save As dialog box, select ..xls type. -- Andy. "Trish" wrote in message ... What is the quickest and easiest way to do the above? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking parameter query from Access to pivot table in Excel | Excel Discussion (Misc queries) | |||
Removing Link to Access Query | Excel Discussion (Misc queries) | |||
1-variable Data Table dependent on MS Query fails to update correctly | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
HELP: Access table linked to Excel - calculated fields? | Excel Worksheet Functions |