ACC2000: Access Help Gives Incorrect Excel Version for OutputTo Action (269539)



The information in this article applies to:

  • Microsoft Excel 2000
  • Microsoft Access 2000

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).

Modification Type:MajorLast Reviewed:6/25/2004
Keywords:kbbug kbpending KB269539