Cannot export Access 2007 Report into Excel

[KrispyData]

Hello!
I am trying to export a report into Excel. The options availabe to me are
Word RTF, PDF, Access Database, Text File, or XML File. Excel is not a
highlighted option. Is this because Access simply does not allow export of
reports to Excel? Or, do I need an add-in?

 

[Jeff Boyce]

Yes, Access 2007 is not able to export a report, from Preview, to Excel. As
I recall, something to do with a lawsuit/settlement.

The data, yes, but the "formatted-for-print" image, no.

So the work-around solution is to export the query, not the report.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KrispyData]

Thank you, Jeff.
I wanted to export the report into Excel because of the charts. I need a
way for charts to be created for each rep, and Access did it pretty well with
Reports. I'm sure Excel can do this with some code or macro. Can you
recommend a tutorial or reference that may help me figure this out?

 

[Jeff Boyce]

So, if you were able to get the data out to Excel (and you can!), you could
use the features/functions in Excel to create the charts?

I'd suggest visiting the Excel newsgroups for leads on creating charts.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Conrad [MSFT]]

The ability to Export to Excel in Access 2007 has been re-implemented in Service Pack 2 which was
just released this week!

Details here:
http://blogs.msdn.com/access/

--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET II - Access Test Team - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[Arvin Meyer MVP]

And here's a direct link to it:

http://www.microsoft.com/downloads/...18-79EA-46C6-8A81-9DB49B4AB6E5&displaylang=en
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com