Microsoft KB Archive/139790

= Converting Lotus Notes Spreadsheet Views into Word =

Article ID: 139790

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Word 6.0 Standard Edition
 * Microsoft Word 6.0a
 * Microsoft Word 6.0c
 * Microsoft Word 6.0 Standard Edition
 * Microsoft Word 95 Standard Edition

-



This article was previously published under Q139790



SYMPTOMS
Lotus Notes v 3.3 can export spreadsheet views and files to a format called "1 2 3 Worksheet." If you try to open a file in this format in one of the Word versions listed above, one of the following errors will occur:

This is not a Lotus 1-2-3 formatted document.

-or-

The file is not the right file type. (Lotus 1-2-3)



CAUSE
The Lotus Notes v 3.3 "1 2 3 Worksheet" export format exports files in Lotus 1-2-3 release 1.0A format. Word will convert only Lotus 1-2-3 release versions 2.0 through 5.0.



WORKAROUND
Use one of the following methods to import the Notes spreadsheet into Word:

Method 1:

For best results, export the spreadsheet in Lotus Notes as a Microsoft Excel worksheet. Structured Text and Tabular Text are formats also available for exporting from Notes. Word will be able to convert all three of these formats.

Method 2:

Export from Notes using the "1 2 3 Worksheet" format. Using Microsoft Excel, import the spreadsheet, save it as a Microsoft Excel workbook and then convert to Word.



MORE INFORMATION
For more information on how to obtain the Lotus 1-2-3 versions 2.0-5.0 converter for Word 6.0 for Windows, query on the following words in the Microsoft Knowledge Base:

obtain and lotus and converter and application and note

