Exporting multiple queries to multiple ranges in the same worksheet

[tobinjames]

I am wondering if anyone can help me figure out what I should be doing in order for me to export multiple queries to multiple ranges in one single excel file.



I have 3 queries, each of which returns records from a different table. I would like to export the results from Query 1 to range A1:J7500 of a worksheet, the results from Query 2 to range K1:O7500 in the same worksheet, and the results from Query 3 to range P1:S7500 in the same worksheet.

I have created a macro with 3 TransferSpreadsheet actions, each referring to a query and the desired range. When I run the macro, the results from Query 1 get exported to A1:J7500, but an error message displays when Access tries to export the results from Query 2 into range K1:O7500. The error message is "Table K1:O7500 already exists".

Is it possible to do what I want to achieve using the TransferSpreadsheet action, or should I be approaching this from a different angle? I have limited VBA skills, so would prefer to avoid having to code something if possible.

[June7]

Check out the examples here http://www.btabdevelopment.com/ts/de...aspx?PageId=10