Microsoft KB Archive/120490

= ACC2: Export to MS Excel Uses Version 4.0 File Format =

Article ID: 120490

Article Last Modified on 6/25/2002

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q120490



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



SYMPTOMS
If you have Microsoft Excel version 5.0 installed on your computer, and you export a table to Microsoft Excel using the Analyze It With MS Excel button, the table is exported to Microsoft Excel 5.0 as a Microsoft Excel version 4.0 spreadsheet. If you make any changes to the sheet in Microsoft Excel and then try to save it, you may receive the message:

  '' was created in a previous version of Microsoft Excel. Do you want to update it to Microsoft Excel 5.0 format?



CAUSE
The Analyze It With MS Excel button exports only in Microsoft Excel version 4.0 file format.



RESOLUTION
To export a table in Microsoft Excel version 5.0 file format, choose Export from the File menu, then select Microsoft Excel 5.0 in the Data Destination box.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. This problem no longer occurs in Microsoft Access version 7.0.



Steps to Reproduce Problem
NOTE: This example assumes that you have Microsoft Excel version 5.0 installed on your computer.

 Start Microsoft Access and open the sample database NWIND.MDB. In the Database window, select the Categories table. Choose the Analyze It With MS Excel button on the toolbar. Once the table is exported to Microsoft Excel, change any cell in the spreadsheet.</li>  From the File menu, choose Save. Note that you receive the message:

<pre class="fixed_text">  'CATEGORI.XLS' was created in a previous version of Microsoft Excel. Do you want to update it to Microsoft Excel 5.0 format? </li></ol>

<div class="references_section">