In Access, you would:
Create a new macro
Select OpenQuery in one Action line. Fill in the text boxes at bottom of
macro for this action.
Select TransferSpreadsheet on the second action line of your macro. Fill in
the text boxes at bottom of macro for this action. The text boxes are
self-explanatory.

HTH,
John


"Pat Dools" wrote:

Hello,

Is there a way to take the results of a select query in an Access database
and export those records to the 'Source' tab of an Excel spreadsheet, and
thus over-write the data that was there to provide 'refreshed' data for the
Pivot Table?

I'd like to put this code behind a command button in my Access application.
Is this possible?
--
Thank you, Patrick