• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

Batch conversion of .123 files

We have acquired a company that has several hundred files with .123 file extensions which can not be opened with excel.  Does any one know of a company or utility to do this?  There is one computer left that can open individually and do a save as but this Pc is dying and of course no there is no software to load on a new machine.
0
jmilligan73034
Asked:
jmilligan73034
  • 3
  • 2
2 Solutions
 
regmigrantCommented:
Excel lost the ability to load Lotus files a few revisions ago. If you can get hold of an older copy - 97/2003 for example it should be able to read them.

however the support was always better for wk4 so you might have to do a save as anyway and I take it you are worried the machine will dies before that's complete. So first thing to do is back them up (yes I know you probably have but some people don't think about it until its too late).

I believe Open office Calc can open lotus files so at least you will have a fall back if the machine dies.
0
 
jmilligan73034Author Commented:
Open Office does not  seem to work with .123 files only .wk4 files
0
 
regmigrantCommented:
I've never tried it but was taking a cue from the Openoffice.org feature guide
http://www.openoffice.org/marketing/2.0/featureguide.html#interoperability

 which has this entry against issue 34806 :-

"The Lotus 1-2-3 import now also loads files of Lotus versions up to 9.7, the file type list box lists the .123 file name extension additionally to the already known .wk1 and .wks extensions. Opening a Lotus 1-2-3 file without selecting a filter type now loads the file into Calc instead of Writer."


Its reiterated at OpenWith.org:-
http://www.openwith.org/programs/openoffice.org

If these are incorrect you can raise an issue with the OpenOffice development team and they may be able to help with a previous version.

The only alternative to this would be to see if you can get that machine copied to a virtual environment or take an image of its hard drive and move it to more stable hardware
0
 
jmilligan73034Author Commented:
Thank you.  I will close my question since my question was a "batch" conversion of 22,000 lotus files not a 1 by 1
0
 
regmigrantCommented:
yes I appreciate that, I did find a routine that claims to handle batch conversions but when I investigated I found it generates errors with 123 files.
http://download.cnet.com/Fantastic-Lotus-1-2-3-Converter/3000-2065_4-75758879.html

Alternatively you could try this link and use a copy of smartsuite (which can open .123)  to create a macro:-
http://www.ecostsoftware.com/ibm-lotus/lotus-smartsuite-millennium-9-8-retail-boxed_p1842?gclid=CICM4qqB2L0CFY3HtAod5TIAUg
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now