Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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