Knowledge Base

ACC97: Access Help Gives Incorrect Excel Version for OutputTo Action

Article ID: 207740

Article Last Modified on 1/23/2007

APPLIES TO

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.

Additional query words: pra docerr documentation error wrong

Keywords: kbbug kbpending KB207740


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.