ACC95: Analyze It w/Excel Fails to Transfer Only Selected Fields

 Last reviewed: June 3, 1997
Article ID: Q141233
The information in this article applies to:
  • Microsoft Access version 7.0

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When you run Microsoft Access version 7.0 under Windows 95, the Analyze It With MS Excel command transfers an entire table to Microsoft Excel instead of only selected columns.

RESOLUTION

Create a query with only the selected fields, and then use the Analyze It With MS Excel command on the query results.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access version 7.0. This problem no longer occurs in Microsoft Access version 7.0a.

MORE INFORMATION

Steps to Reproduce Problem

  1. Open the sample database Northwind.mdb.

  2. Open the Order Details table in Datasheet view.

  3. Select the Product and UnitPrice columns.

  4. On the Tools menu, click OfficeLinks, and then click Analyze It With MS Excel. Note that Microsoft Access transfers the entire Order Details table instead of only the two columns that you selected.

REFERENCES

For more information about the Analyze It With MS Excel command, search on the phrase "Analyze it with MS Excel," and then view "Load the output of a datasheet, form, or report into Microsoft Excel," using the Answer Wizard from the Microsoft Access for Windows 95 Help menu.

Keywords : EvnOs IntpOthr kbinterop
Version : 7.0
Platform : WINDOWS
Hardware : X86
Issue type : kbbug
Resolution Type : kbfix

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 3, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.