KB139790 - Converting Lotus Notes Spreadsheet Views into Word

Article ID: 139790

Article Last Modified on 8/17/2005

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

REFERENCES

Lotus Notes Help - Index, Export, Exporting Views to Spreadsheets.

Additional query words: 6.00a 6.00c word6 ntword wordnt word7 word95 convert converted converts conversion translate translated translates translation transfer transferred transfers transferring open opening saving as save lotusnotes 123 lotus123

Keywords: kbconversion KB139790