Run queries and export into excel

[moloff]

Please bear with me. I am well versed in Excel VBA, but not at all familiar
with Access. Last year I took over a piece of equipment that collects data
from a process. The person who set up the data collection scheme has since
moved on and left the company. He set up a couple of queries that are
accessed from a form where start and end time are requested. Following that
you can press different buttons to pull the data from that experiment.
Following the query, the user is asked to go to Tools and Analyze with Excel
to get the data into excel. For my work, I do two different queries and add
them to one excel spreadsheet followed by some excel macros. I can do this
easily, however, I would much prefer to have a macro that runs two queries,
and add them both to one Excel work book but two different sheets. Can
anyone help me?

Thanks!

These are my queries:

PARAMETERS Forms![Data Extract Form]!Start DateTime, Forms![Data Extract Form]
![End] DateTime;
TRANSFORM Avg(Basic.Val) AS [The Value]
SELECT Basic.DateAndTime
FROM Basic
WHERE (((Basic.TagName) Like "alarms\e_stop_pressed" Or (Basic.TagName) Like
"mmi_temps\*") And ((Basic.DateAndTime) Between Forms![Data Extract Form]!
Start And Forms![Data Extract Form]!End))
GROUP BY Basic.DateAndTime
PIVOT Basic.TagName;


PARAMETERS Forms![Data Extract Form]!Start DateTime, Forms![Data Extract Form]
![End] DateTime;
TRANSFORM Avg(Basic.Val) AS [The Value]
SELECT Basic.DateAndTime
FROM Basic
WHERE (((Basic.TagName) Like "buttons\*" Or (Basic.TagName) Like "unit\
cycle_step" Or (Basic.TagName) Like "unit\mmi_v*") And ((Basic.DateAndTime)
Between Forms![Data Extract Form]!Start And Forms![Data Extract Form]!End))
GROUP BY Basic.DateAndTime
PIVOT Basic.TagName;

 

[golfinray]

Try here first. http://www.accessmvp.com/KDSnell/EXCEL_MainPage.htm