sending report to excell

[Cynthia]

Some one please help.... I need to send a report to excell after the user has
clicked the icon to open the report. I am currently doing this by calling
the same query to dump to excell as I am using on the report, This query is
slow is there any way to do this without calling the query twice?

 

[John Nurick]

Hi Cynthia,

Can you just train the user to click Tools|Office Links|Analyse it with
Excel while the report is open in preview mode?

 

[Cynthia]

They want this automated in case the user forgets, these are issued reports
and we need a excell file created for each issue.

 

[John Nurick]

In that case you could use a temporary table to avoid running the query
twice:
1) run a delete query to empty the temporary table
2) run your slow query to append up-to-date records to temp table
3) open the report (now based on the temp table)
4) export the contents of the temp table.

 

[WarEagleDan]

Not trying to hijack this thread, but does anyone know where TOOLS/OFFICE
LINKS/ANALYZE IT WITH EXCEL is in ACCESS 2007? thanx

 

[Paul Shapiro]

I don't use this feature much, but I seem to remember Access 2007 does not
support exporting a report to Excel. You can export the query which is the
report's recordsource.