Access Report to Excel Worksheet

  • Thread starter Thread starter DogmaDot
  • Start date Start date
D

DogmaDot

I prepare a monthly report in ACCESS which when complete I save to EXCEL as
my boss prefers EXCEL. I recently converted to MS Office 2007 from 2003. I
was able to create the EXCEL file before, and I THINK I did it in 2007.
However, now when I run the report and look at it as "report" the EXCEL icon
is dimmed. The WORD and TEXT options are available. I suspect I've turned
something off but don't know what.

HELP!!!!
 
No you did not turn anything off. Microsoft did as the result of losing a
lawsuit on copyright infringement.

If I recall correctly, they were able to reinstitute the feature in the latest
service pack to 2007. That is a vague memory, so I could be totally off base.

Have you considered exporting the report's source (query) instead of trying to
convert the report to Excel?

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
I have been looking for a conversion to excel for years. I am not involved
with the product (deskUNPDF) but it looks promising for taking a PDF and
converting it to Excel. It creates a single worksheet for multiple pages. The
other solution I have had "some" success iwith s to convert a PDF to html
4.01 and convert that to Excel.
 
Back
Top