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

ID: Q237576

The information in this article applies to:

Microsoft Access 2000

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

This article applies to a Microsoft Access database (.mdb) and 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.

MORE INFORMATION

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 : kbdta IsmExl5
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb