Cannot export Access 2007 Report into Excel

  • Thread starter Thread starter KrispyData
  • Start date Start date
K

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?
 
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
 
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Report 2
Exporting aces report table 2007 to excdel 2007 1
export report to excel 1
Access 2007 Report Formats -- Export to Excel 7
Exporting Report to Excel 2
How can I export a report to Word and retain images? 2
Word to Excel: Export comments with text and line number 0
Export to XML - error 31532 0

Back
Top