Macro to paste query into Excel

[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!!!!

 

[sdk]

Hi,

you can use the "Ouput To" macro command to send a table/query to a speadsheet.

You can also, with code, create and insert data to workbook cell range (you cannot do this with macros).

Cheers

Steve