Macro to paste query into Excel 1

[gard0128]

We are currently updating an Excel file from two queries in Access by cutting and pasting the data.

Is there a way to create a macro that would run the query, open the excel file and paste the data into a "data" worksheet?...or is there a better way?

Thanks for any help!!!!

 

[VulcanJedi]

better way, goto menubar:

DATA, Import External Data, New Database Query.

Lesser know features of excel, you can actually link and build you queries from XL, filter and auto refresh data, I think this is waht you are lookin for. Tranpkp

 

[gard0128]

When I attempt to "Finish" in setting up the query, I get the msg: "Too few parameters, expected 1"

Is this because my Access query has a parameter? (the user needs to key in the month criteria when running the query)