Can the results set of a query be saved to an Excel file, without any links to the original tables?
D Dave Cullen Jan 29, 2004 #1 Can the results set of a query be saved to an Excel file, without any links to the original tables?
S Steve Schapel Jan 29, 2004 #2 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.
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.
