Microsoft KB Archive/269539

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

Article ID: 269539

Article Last Modified on 6/25/2004

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q269539



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



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



CAUSE
The error is in the Access 2000 Help file, not in the functioning of Access or Excel.



STATUS
Microsoft has confirmed that this is a problem in Microsoft Access 2000.



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

Steps to Reproduce the Behavior

 * 1) Start Microsoft Access and open the sample database Northwind.mdb.
 * 2) In the Database window, click Macros under Objects, and then click New.
 * 3) In the Action column, type 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 ExcelTest.
 * 7) On the Tools menu, point to Macro, and then click Run Macro. In the Run Macro dialog box, select ExcelTest under Macro Name, and then click OK to run the macro.
 * 8) In the OutputTo dialog box, click OK to save the file as Customers.xls.
 * 9) Start Microsoft Excel and open the Customers.xls file.
 * 10) On the File menu, click Save As.

Note that the file format shown in the Save as type box is Microsoft 5.0/95 Workbook (*.xls).

Additional query words: pra docerr documentation error wrong

Keywords: kbbug kbpending KB269539

-

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

© Microsoft Corporation. All rights reserved.