How do I copy and link a query from MS Access into MS Excel

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

Guest

I am trying to have a query from Microsoft Access pasted and linked to a
Microsoft Excel File. Please, if any one has any insight on what I am trying
to accomplish, please contact me. Thank you.
 
That will not work; however, what you want to do is use MSQuery within Excel
to pull data from Access.
Open your Excel file, then Data, Import External Data, New Database Query.
It is enought like an Access query you wont have any troulbe making it work
for you.
 
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

Access #Error & Excel Pivot 0
Linking Access worksheet and appending data to Access table 4
Access Import & Link section grayed out MS Access 2010 1
How to export table from outlook into ms access table? 0
Access OLE Data to Excel 1
Exporting a Access Query 4
Link to Excel through Database Ms Query from a User level secured 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top