ACC2: Export to MS Excel Uses Version 4.0 File Format

• Microsoft Access version 2.0

SYMPTOMS

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

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:

   '<Spreadsheet name>' 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.

MORE INFORMATION

Steps to Reproduce Problem

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

1. Start Microsoft Access and open the sample database NWIND.MDB.

2. In the Database window, select the Categories table.

3. Choose the Analyze It With MS Excel button on the toolbar.

4. Once the table is exported to Microsoft Excel, change any cell in the spreadsheet.

5. From the File menu, choose Save. Note that you receive the message:

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

REFERENCES

For more information about using the Analyze It With MS Excel button to export to Microsoft Excel, search for "Analyze It button," and then "Output To MS Excel button" using the Microsoft Access Help menu.