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