Access 2007-exporting reports in Excel

[Deena Walter]

I export reports to Excel....I just upgraded from Office 2003 to 2007. I got everything upgraded correctly, except excel is not an option anymore when you run a report. Anyone know the work around on this or what I can do to have Excel be an option under the report function?

Thanks
Deena

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[Allen Browne]

That's correct, Deena. Access 2007 no longer gives you the ability to export
a report to Excel.

You can export a query: use TransferSpreadsheet in a macro or code.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

in message
news:[email protected]...

 

[Wesley Wildman]

Allen, What is the reasoning behind disallowing the export of reports to
Excel in Office 2007? some of my clients would regard that as a good reason
not to upgrade to Office 2007. A report can get a lot of work done beyond
what is already in the underlying query, and it can be time-consuming and
unreliable to reconstruct calculated fields etc. after exprting a query to
Excel, not to mention worrying about layout. Wesley

 

[Allen Browne]

I don't know why Microsoft removed this feature in the new version. It does
upset some people, and if you need a reference for your client, we have it
listed here:
http://allenbrowne.com/Access2007.html#Gone

Having said that, exporting reports always had problems anyway. There were
problems with blank lines, handling of page breaks in the data, and handling
of subreports. To me, it never seemed an efficient way to do more than send
a picture of the data, and the new version does that by exporting to PDF.

Certainly the sorting'n'grouping and aggregating in reports was a handy way
to interface this kind of thing. But you can achieve most of that in queries
if you need to: totals queries, stacked queries (queries into other
queries), subqueries (queries with an embedded SELECT), total queries (GROUP
BY), and so on.

 

[Wesley Wildman]

Thanks, Allen.

I love the pdf export in Access 2007. But some clients want and need to
spontaneously reanalyze complex report data or visually explore report data
by creating graphs in Excel. They don't want to wait around and request a new
report from a programmer, and they wouldn't bother anyway. They want to
answer the questions that occur to them in their own way right then and
there. The pdf picture of the report doesn't get the job done, and the
cosmetic idiosyncracies of exporting to Excel are irrelevant for this purpose.

The Access 2007 approach interferes with a lot of that spontaneity by
presuming either a passive interpreter of data or an interpreter that only
cares about flawless layout. I think that those assumptions about users are
wide of the mark, at least when it comes to serious data analyzers. We will
all just have to adjust, I guess.

I sure have appreciated your website over the years. Did you see the Dockers
beat the Eagles last week?

Wesley

 

[Allen Browne]

Thanks, Allen.
[snip]
I sure have appreciated your website over the years. Did you see the
Dockers
beat the Eagles last week?

Wesley

Yes: surprise result.