Microsoft KB Archive/237576

= ACC2000: "Analyze It with MS Excel" Command Exports to Excel 5.0/95 File Format =

Article ID: 237576

Article Last Modified on 6/28/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q237576



Novice: Requires knowledge of the user interface on single-user computers.

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



SYMPTOMS
When you use the Analyze It with MS Excel command on the Office Links submenu on the Tools menu to export a table, the table is exported to a Microsoft Excel 5.0/95 Workbook (.xls) format. This happens even if you have a version of Excel later than 5.0 or 95 on your computer.



RESOLUTION
After you have exported the table by using the Analyze It with MS Excel command, click Save as on the File menu in Excel to save it in a later file format.

To export a table directly to a Microsoft Excel 97-2000 Workbook (.xls) format, use the Export command on the File menu in Access. This enables you to select the Excel format to which you want to export.



Steps to Reproduce Behavior
 Open the sample database Northwind.mdb. In the Database window, click Tables under Objects, and then click to highlight the Shippers table. Click the Analyze It with MS Excel button on the Database toolbar. After the table is exported to Excel, on the File menu click Save. Note that you receive the message:

'Shippers.xls' is a Microsoft Excel 5.0/95 Workbook. Do you want to overwrite it with the latest Excel format?



Additional query words: prb

Keywords: kbprb KB237576

-

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

© Microsoft Corporation. All rights reserved.