Can Access 2007 analyze w/Excel?

[CEV]

I have installed Office 2007 and I am not able to locate the option to
Analyze a report with Excel. I was able to do this with Access 2003 and it
would put all the data from a report into an Excel file. How do I do this in
Access 2007? I do not see the option anywhere after opening the report.

Thanks,

CEV

 

[CEV]

I forgot to mention that when I have the report open, The export to Excel
option is greyed out as is the sharepoint list option right next to it.

Thanks,

CEV

 

[Rick Brandt]

I forgot to mention that when I have the report open, The export to
Excel option is greyed out as is the sharepoint list option right
next to it.

Apparently the ability to do this *for reports* was removed.

 

[Peter Yang[MSFT]]

Hello Chad,

This feature has been depreciated from Access 2007. The workaround is to
either export the underlying table/query to Excel. Please see the following
article for details:

You cannot export a report to an Excel format in Access 2007
<http://support.microsoft.com/kb/934833/en-us>

Also, you can download one of the add-ins like PDF or XPS format converters
as described in above link.

Please rest assured that your feedback on this feature is routed to the
proper channel. If you have any further concerns, please feel free to let's
know. Thanks.

Best Regards,


Peter Yang

Microsoft Online Community Support

Get Secure! - www.microsoft.com/security

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[CEV]

I never thought I would lose features after "upgrading" to a newer version.
Good to know though. This will help in my decision to roll it out to the
rest of the organization.

CEV

 

[Guest]

Another workaround is to change your report to a form. You can export a form
to Excel.

I never thought I would lose features after "upgrading" to a newer version.
Good to know though. This will help in my decision to roll it out to the
rest of the organization.

CEV

Hello Chad,

This feature has been depreciated from Access 2007. The workaround is to
either export the underlying table/query to Excel. Please see the
following
article for details:

You cannot export a report to an Excel format in Access 2007
<http://support.microsoft.com/kb/934833/en-us>

Also, you can download one of the add-ins like PDF or XPS format
converters
as described in above link.

Please rest assured that your feedback on this feature is routed to the
proper channel. If you have any further concerns, please feel free to
let's
know. Thanks.

Best Regards,


Peter Yang

Microsoft Online Community Support

Get Secure! - www.microsoft.com/security

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.