ACC2000: "Analyze It with MS Excel" Command Exports to Excel 5.0/95 File FormatID: Q237576
|
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.
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.
'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
Last Reviewed: August 9, 1999