ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Importing a table from Access query (https://www.excelbanter.com/excel-discussion-misc-queries/25788-importing-table-access-query.html)

Trish

Importing a table from Access query
 
What is the quickest and easiest way to do the above?

Thanks in advance.


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.





All times are GMT +1. The time now is 05:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com