Converting Lotus Notes Spreadsheet Views into Word (139790)


The information in this article applies to:

  • Microsoft Word for Windows 6.0
  • Microsoft Word for Windows 6.0a
  • Microsoft Word for Windows 6.0c
  • Microsoft Word for Windows NT 6.0
  • Microsoft Word for Windows 95
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.
Modification Type:MinorLast Reviewed:8/17/2005
Keywords:kbconversion KB139790
©2004 Microsoft Corporation. All rights reserved.