If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2007-exporting reports in Excel
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 |
#2
|
|||
|
|||
Access 2007-exporting reports in Excel
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 ... 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 |
#3
|
|||
|
|||
Access 2007-exporting reports in Excel
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. |
#4
|
|||
|
|||
Access 2007-exporting reports in Excel
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 he 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" wrote in message ... 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. |
#5
|
|||
|
|||
Access 2007-exporting reports in Excel
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 he 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" wrote in message ... 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. |
#6
|
|||
|
|||
Access 2007-exporting reports in Excel
"Wesley Wildman" wrote in message
... 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. |
Thread Tools | |
Display Modes | |
|
|