Microsoft KB Archive/207740

= ACC97: Access Help Gives Incorrect Excel Version for OutputTo Action =

Article ID: 207740

Article Last Modified on 1/23/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.