Re: Converting Data in a Report to Excel
- From: "Jeff Boyce" <nonsense@xxxxxxxxxxxx>
- Date: Tue, 25 Mar 2008 15:51:40 -0700
Wendy
Microsoft "greyed out" the capability of exporting an Access report to Excel
.... you can still send to Word, but no longer to Excel directly from the
report.
Here's a work-around I'm using:
Export the QUERY that would feed the report, instead of the report
itself.
Good luck!
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Wendy" <Wendy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:83659489-25B6-401A-AA74-F58DD4DEAD69@xxxxxxxxxxxxxxxx
In Office 2003 you were able to export data in a report directly to Excel
by
clicking on a button. In Office 2007 the "Excel button" is grayed out when
you are viewing a report. I read in the Help of Office 2007 and it appears
you can no longer export data from a report. I wanted to make sure I
wasn't
missing something since I could do this previously. Thoughts?
.
- Prev by Date: Re: reports view doesn't run footer_format function
- Next by Date: Layout view
- Previous by thread: Re: Converting Data in a Report to Excel
- Next by thread: Re: Multi-Level GROUP By Clause is not allowed in subquery
- Index(es):
