sending report to excell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
They want this automated in case the user forgets, these are issued reports
and we need a excell file created for each issue.
 
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.
 
Not trying to hijack this thread, but does anyone know where TOOLS/OFFICE
LINKS/ANALYZE IT WITH EXCEL is in ACCESS 2007? thanx
 
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.
 
Back
Top