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.
 
Back
Top