How to open Lotus 123 files

  • Thread starter Thread starter Jason B [MVP-Storage]
  • Start date Start date
J

Jason B [MVP-Storage]

Everything that I read says that Excel 2003 doesnt need a converter ... but
I cant open a .123 file...

Any ideas would be greatly appreciated...

jason
 
Jason B [MVP-Storage] wrote...
Everything that I read says that Excel 2003 doesnt need a converter .... but
I cant open a .123 file...

Any ideas would be greatly appreciated...
Click to expand...

Whatever you're reading, either you're not reading it carefully or it
was written sloppily. Excel from version 95 on has been able to read
..WK4 (Lotus 123 Release 4 format) files and *PREVIOUS* 123 file formats
(.WK3/.WK1/.WKS), but *NO* version of Excel yet has been able to read
..123 (123 97 and 123 release 9.x) format files.

Aside from hex editors, the **ONLY** software packages that can do
anything useful with .123 files at this time are Lotus 123 Releases 97
and 9.x, Quattro Pro version 10 (WordPerfect Office 2002) and later,
and (claimed, but I haven't verified) DataViz's ConversionPlus. Of all
of these, 123 does the best job with them (no surprise).

So unless you can get whoever sent you this file/these files to resave
them in .XLS format and send you the .XLS files, you're going to have
to buy and install the latest version of Lotus SmartSuite (WPO may be
cheaper, but it's certain to be buggier, and ConversionPlus will be
much more expensive) if you want to do anything with these files.
 
Thanks Harlan ...



Harlan Grove said:
Jason B [MVP-Storage] wrote...
Everything that I read says that Excel 2003 doesnt need a converter ... but
I cant open a .123 file...

Any ideas would be greatly appreciated...
Click to expand...

Whatever you're reading, either you're not reading it carefully or it
was written sloppily. Excel from version 95 on has been able to read
.WK4 (Lotus 123 Release 4 format) files and *PREVIOUS* 123 file formats
(.WK3/.WK1/.WKS), but *NO* version of Excel yet has been able to read
.123 (123 97 and 123 release 9.x) format files.

Aside from hex editors, the **ONLY** software packages that can do
anything useful with .123 files at this time are Lotus 123 Releases 97
and 9.x, Quattro Pro version 10 (WordPerfect Office 2002) and later,
and (claimed, but I haven't verified) DataViz's ConversionPlus. Of all
of these, 123 does the best job with them (no surprise).

So unless you can get whoever sent you this file/these files to resave
them in .XLS format and send you the .XLS files, you're going to have
to buy and install the latest version of Lotus SmartSuite (WPO may be
cheaper, but it's certain to be buggier, and ConversionPlus will be
much more expensive) if you want to do anything with these files.
Click to expand...
 
I've not tried this yet, but...

OpenOffice.org 2.0 Office Suite
"...The Lotus 1-2-3 import now also loads files of Lotus versions up to 9.7
...."

(about 1/2 way down the page)

http://marketing.openoffice.org/2.0/featureguide.html#interoperability

HTH
--
Dana DeLouis
Win XP & Office 2003


Jason B said:
Thanks Harlan ...



Harlan Grove said:
Jason B [MVP-Storage] wrote...
Everything that I read says that Excel 2003 doesnt need a converter ... but
I cant open a .123 file...

Any ideas would be greatly appreciated...
Click to expand...

Whatever you're reading, either you're not reading it carefully or it
was written sloppily. Excel from version 95 on has been able to read
.WK4 (Lotus 123 Release 4 format) files and *PREVIOUS* 123 file formats
(.WK3/.WK1/.WKS), but *NO* version of Excel yet has been able to read
.123 (123 97 and 123 release 9.x) format files.

Aside from hex editors, the **ONLY** software packages that can do
anything useful with .123 files at this time are Lotus 123 Releases 97
and 9.x, Quattro Pro version 10 (WordPerfect Office 2002) and later,
and (claimed, but I haven't verified) DataViz's ConversionPlus. Of all
of these, 123 does the best job with them (no surprise).

So unless you can get whoever sent you this file/these files to resave
them in .XLS format and send you the .XLS files, you're going to have
to buy and install the latest version of Lotus SmartSuite (WPO may be
cheaper, but it's certain to be buggier, and ConversionPlus will be
much more expensive) if you want to do anything with these files.
Click to expand...
Click to expand...
 
Dana DeLouis wrote...
I've not tried this yet, but...

OpenOffice.org 2.0 Office Suite
"...The Lotus 1-2-3 import now also loads files of Lotus versions up to 9.7
..."
Click to expand...
....

OOo 2.0 is still in beta. I've been using it for a few months, but I
hadn't noticed this feature. It works for VERY SIMPLE .123 files, but
is nowhere near ready for prime time. One of the more annoying things
is that it can't handle multiple worksheets in .123 files. It
invariably names the first worksheet Sheet1 and *ALL* subsequent
worksheets temp. However, if the file the OP has contains only a single
worksheet or nothing but constants and formulas referring to ranges
only in the same worksheet, it may be adequate to extract the data.
 
Back
Top