Transferring data from different Access queries to one Excel file.

[Guest]

I have several queries and macros (relating to those queries) set up in
Access so that when I receive information from an email I can save the data
in Access and then click on a macro and have the information exported into
excel. However, I would like to export three different queries using the
macros I created into one excel file. Any suggestions? I use Microsoft ME.

Thanks.

 

[Alex Dybenko]

Hi,
i think you have to use automation to perform such task. This article will
give you an idea of it:
http://support.microsoft.com/default.aspx?scid=kb;en-us;146406

 

[John Nurick]

Put three successive TransferSpreadsheet actions in one macro, one for
each query. Put the worksheet names you want into the Range argument for
each TransferSpreadsheet, with an exclamation mark after each, e.g.
MyQuery1!

(I'm not certain that this works with macros; it does work with the VBA
equivalent, DoCmd.TransferSpreadsheet.)