Analyze with Excel in Access 2007

B

Brandi

My company recently upgraded to Access 2007 and it now appears that you can
longer Analyze a report with excel anymore. Does anyone know how to go about
this?
 
D

Danny J. Lesandrini

It's easy. You can right click the table or query and choose Export | Excel
or open the table, query or report and select the External Data tab of the
ribbon. Now click on the Excel button
 
W

WarEagleDan

Au contraire! They've taken an easy 2 click task and made it 4 clicks with a
big ugly box! Arrggghhhh!
 
R

Rick Brandt

It's easy. You can right click the table or query and choose Export |
Excel or open the table, query or report and select the External Data
tab of the ribbon. Now click on the Excel button
Click to expand...

The option to do this for *reports* though was removed in 2007.
 

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

Calculate the median value before a specified list 0
Outlook Loses Login/Password on Exchange After CCleaner Runs 0
Menu Macro Not Executing - Need Help 1
analyze data with excel feature in office 2007? 2
Justification function versus wide spaces 0
Analyze with Excel 0
Active Content in this file is blocked issue 1
Working outlook via vba code with xlsx - error 0

Top