Export multiple query's to multiple sheet excel

[vaikz]

Hi, good day.


My problem is how to export multiple query to excel, where each query will be exported to each worksheets and cell range on 1 workbook.
Let say:
query1 = worksheet1 B6
query2 = worksheet2 C5
and so on ...
It will also nice if it will automate the name of the worksheets from the name of the query.

What is the best and effective way to do this?

Thanks in advance.

[ssanfu]

How good are your VBA programming skills?? Check out Ken Snell's site at:
http://www.accessmvp.com/KDSnell/EXCEL_Export.htm

[vaikz]

Thanks for the reply ssanfu.

I'm not really that good but I understand vba . I've done exporting data to excel but most
of the time only 1 table to 1 worksheet. I was also able to use datapigs access explosion.
I don't have problem exporting 1 query but i've got no success exporting the next query.

I'll check the link.

[ragsgold]

Thanks for the reply ssanfu.

I'm not really that good but I understand vba . I've done exporting data to excel but most
of the time only 1 table to 1 worksheet. I was also able to use datapigs access explosion.
I don't have problem exporting 1 query but i've got no success exporting the next query.

I'll check the link.

Vaikz

You can use the following Macro "Transfer spreadsheet" in versions 2007 and below or importexportspreadsheet in Access 2010

Create as many commands to the extent of your query list and repeat the process. For instance if you have 10 queries use it 10 times and in all 10 cases give the destination location file name. Same file name is important because thats how you can export all your queries into same file but different sheet names.

When you execute the macro i will export each query to the same file but in different tabs (name your individual queries in access to the name you want in the excel sheet names) in the excel. 1 macro how many ever queries you have you can include them in that. try it and let me know how this works for you.

[vaikz]

thanks a lot ragsgold

I already solve this one long time ago, I just forgot to mark it solve. And in fact its the same method I use on what you suggested. Thanks a lot.