Access 2007-exporting reports in Excel

Deena Walter · External Since: Aug 08, 2007 Posts: 1

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 · External Since: Nov 08, 2003 Posts: 7201

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
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Deena Walter" wrote in message
news:20078834513tennisgirl247@hotmail.com...
>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

Wesley Wildman · External Since: Aug 07, 2007 Posts: 3

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" wrote:

> 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 · External Since: Nov 08, 2003 Posts: 7201

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Wesley Wildman" <WesleyWildman DeleteThis @discussions.microsoft.com> wrote in message
news:C0DA061F-8F0A-43F3-96DF-AC49E2BD9227@microsoft.com...
> 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" wrote:
>
>> 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.
>

Wesley Wildman · External Since: Aug 07, 2007 Posts: 3

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" wrote:

> 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.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Wesley Wildman" <WesleyWildman DeleteThis @discussions.microsoft.com> wrote in message
> news:C0DA061F-8F0A-43F3-96DF-AC49E2BD9227@microsoft.com...
> > 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" wrote:
> >
> >> 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 · External Since: Nov 08, 2003 Posts: 7201

"Wesley Wildman" <WesleyWildman RemoveThis @discussions.microsoft.com> wrote in message
news:763A8999-1D41-47C0-8343-F344D4C8206D@microsoft.com...
> 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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.