ACC97: Access Help Gives Incorrect Excel Version for OutputTo Action (207740)


The information in this article applies to:

  • Microsoft Access 97
  • Microsoft Excel 97 for Windows
This article was previously published under Q207740
Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

The Microsoft Access Help topic for the OutputTo action states that this macro action outputs data to Microsoft Excel 97 format. However, when you open the exported Microsoft Excel spreadsheet in Microsoft Excel 97, you notice that the format is actually Microsoft Excel 5.0/95.

CAUSE

This is an error in the Access 97 Help file.

STATUS

Microsoft has confirmed that this is a problem in Microsoft Access 97.

MORE INFORMATION

Even though Microsoft Excel displays the format as Microsoft Excel 5.0/95, Microsoft Excel 97 can still open this data file. The conversion is understood.

Steps to Reproduce the Behavior

  1. Open the sample database Northwind.mdb.
  2. Click the Macro tab, and then click New.
  3. In the Action column, enter OutputTo.
  4. In the Object Name list, click the Customers table.
  5. In the Output Format box, click Microsoft Excel (*.xls).
  6. Save the macro as Excel97Test.
  7. On the Macro menu, click Run to run the macro.
  8. Open the file in Microsoft Excel 97.
  9. On the File menu, click Save As.
Note that the file format shown is Microsoft 5.0/95.
Modification Type:MajorLast Reviewed:10/22/2003
Keywords:kbbug kbpending KB207740
©2003 Microsoft Corporation. All rights reserved.