Exporting Query to Excel Table

[herbc0704]

I created a a query in Access. I need to export this query results to a table that has a formatted pivot table attached. I need for the information in the export to overright the existing information excel table so the pivot table can refresh with new information.

I tried using the data import in excel, but since my access query has prompt parameters in it it does not allow that, or is there a way to work around that.

 

[Trevor G]

In Access look at MACROS and you will find TransferSpreadSheet as an option, you can then use the Export and specify the workbook name and path and also the range to go to, that should replace existing data.

 

[jasmith4]

In Excel open the file with the pivot table, click in it, then open the Pivot Table Wizard from the toolbar, and click Back to get to where the data come from. You should choose External List or Database, then make an ODBC connection to the Access database, specifically the query you want.