View Single Post
  #4  
Old July 20th, 2004, 01:12 AM
Brigitte P
external usenet poster
 
Posts: n/a
Default Export access reports data into excel sheets

I think you can just click on the report (not open it, just select it) and
use Tools, Office Links, Excel. But I think you would get a cleaner result
if you export the underlying query to Excel and then format your report in
Excel. If you rather export the report, you may lose the formatting. Any
calculations are done just as easy in Excel as they are done in Access, and
it is quicker.
As a rule, I format any reports that are used again and again in Access, but
I export data that is for one time use only into Excel and format it quickly
in Excel.
Brigitte P.


"Praveen" wrote in message
...
Hi,

I have some Access reports and I want to export those reports (data ) into
Excel. Is this possible?
I have researched on this, and I figured how to export the data in the

table
to the excel but not the data in the report. Could you guys, please help

me
on this?