Export Queries To Current Active Spreadsheet

[carlnewboult]

Hiya,

Not sure if this is possible but am really hope that it is as it takes me ages to enter it manually. I have several queries which need to enter the information they produce into a spreadsheet. I have done this before simply by linking the spreadsheet to the access database. However this time the spreadsheet could be a wide range of different names and stored in different locations. What I want to know is can I export a query to the spreadsheet which is currently open ?

Thanks in advance people.

 

[Pat Hartman]

Please don't start multiple threads on the same topic.