Help: Download Report from Access to Excel

[Anne]

Hello guys,

After working for quite several years,this is my first
time doing Access and I really need helps on how or what
are the steps needed in order to download a report into
Excel format ?

Much more appreaciate if someone could share me the
sample.

Million thanks.

Waiting for answers,
Anne

 

[Allen Browne]

When you preview the report, there is an Office Links icon on the toolbar.
You can use that to "Analyze with Excel".

If it's the data you want (rather than the layout), you will generally get
better results by using the TransferSpreadsheet action on the query that the
report is based on.