Copy queries into excel.

[Roly Reefer]

i need to setup a load of queries on an access database with corresponding reports (pivots). i want to copy the data into the corresponding spreadsheet to the end of the data when each query button is pressed, so the reports are automatically updated when the query is ran.

how can i do this in vba? thanks very much.

 

[DCrake]

Should you not be dling this in reverse.

Attaching the queries to the workbook and refreshing the data from Excel