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

analyze data with excel feature in office 2007? 2
Analyze a report in excel in 07 1
access2007 reports 7
Analyze with Excel - Office 2007 1
Analyze with Excel Issue 5
Analyze Survey Results in Access - Matrix form 0
Analyze It with Microsft Excel 1
Can Access handle 50 million rows of data or more? 16

Top