Transferring data from different Access queries to one Excel file.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SWgirl - 30 Mar 2005 22:29 GMT

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.

Reply to this Message

Alex Dybenko - 31 Mar 2005 09:46 GMT

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

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

>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
[quoted text clipped - 5 lines]
>
> Thanks.

Reply to this Message

John Nurick - 31 Mar 2005 20:19 GMT

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.)

>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
[quoted text clipped - 3 lines]
>
>Thanks.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message