Saving query to file

  • Thread starter Thread starter Dave Cullen
  • Start date Start date
D

Dave Cullen

Can the results set of a query be saved to an Excel file, without any
links to the original tables?
 
Dave,

See under the File|Export menu. If you need to automate this via a
macro or VBA procedure, you would use the TransferSpreadsheet action/method.
 
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

Query is too complex after install Access 2007 SP 2 !? 25
Problem: Slow query design window using linked a tables over network. 1
Join Query 2
Access 2003 query to Excel 2007 problem? 4
Query Key 3
linked worksheet connection error 5
Query field size quandry 2
Why does Access 2007 save query changes w/o prompting? 1

Back
Top