Transferring Data from Access to Excel

[smurf01]

Hi Everyone, help required
I have created a form in Access that returne some info what i would like to do is to automatically return the data to an excel spreadsheet and also create a pivot table in excel.

I have tried using Office Links however, this just overwrites my spreadsheet and then the macro i created to run the pivot table format goes also.

Can i create some code in Access that will run the query, open Excel, paste the data and run my macro to create the pivot table

Thanks Paul