What does Analyze with Excel actually do?

  • Thread starter Thread starter Dino
  • Start date Start date
D

Dino

I'm trying to figure out what the Analyze It with Microsoft Excel option
(under Tools, Office Links), actually does other than open a copy of the
datasheet in Excel. Is it linked in any way back to the Access database? I
see that it saves a copy of the table as an Excel workbook, but does it do
anything other than that?

Thanks,
Dino
 
Dino said:
I'm trying to figure out what the Analyze It with Microsoft Excel option
(under Tools, Office Links), actually does other than open a copy of the
datasheet in Excel. Is it linked in any way back to the Access database? I
see that it saves a copy of the table as an Excel workbook, but does it do
anything other than that?
Click to expand...

It is the OutputTo method as a menu object. You are correct, it doesn't do
anything more than save a datasheet as an Excel spreadsheet.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
You must log in or register to reply here.

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 with Excel - Office 2007 1
Analyze with Excel in Access 2007 3
Analyze with Excel Issue 5
analyze data with excel feature in office 2007? 2
Analyze Survey Results in Access - Matrix form 0
Analyze in excel 2
Using Analyze It with MS Excel 1
Analyze It with Microsft Excel 1

Back
Top