Export Query To Specific Cell

[carlnewboult]

Hiya,

At present I am running a database which opens several queries and then I have to manually paste this informaiton into a spreadsheet.

What I want to know is how do i go about pasting this information into a specific spreadsheet and then into the correct cell.

I have had a look around and have not been able to find what I am looking for.

Cheers

Carl

 

[reclusivemonkey]

At present I am running a database which opens several queries and then I have to manually paste this informaiton into a spreadsheet.

What I want to know is how do i go about pasting this information into a specific spreadsheet and then into the correct cell.

I have had a look around and have not been able to find what I am looking for.

Try

DoCmd Transferspreadsheet

or

DoCmd OutputTo

and one should do what you need. If you have several queries, make the export a function with an argument for the query name and output location, then just call them with the function every time.