Importing a table from Access query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

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

See a number, read a date 2
How to export table from outlook into ms access table? 0
pricing 2
importing/linking data from an Access 2003 Query to an Excel 2003 2
Not all Access queries can be imported 1
copy email to flash drive 1
Copy cell shortcut needed 2
Ms Access and Ebay... How to link the 2 together? 3

Back
Top