Solved

Batch conversion of .123 files

Posted on 2014-04-02
5
283 Views
Last Modified: 2014-04-11
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
Comment
Question by:jmilligan73034
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 19

Assisted Solution

by:regmigrant
regmigrant earned 500 total points
ID: 39978334
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
 

Author Comment

by:jmilligan73034
ID: 39989334
Open Office does not  seem to work with .123 files only .wk4 files
0
 
LVL 19

Accepted Solution

by:
regmigrant earned 500 total points
ID: 39992044
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
 

Author Closing Comment

by:jmilligan73034
ID: 39992342
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
 
LVL 19

Expert Comment

by:regmigrant
ID: 39993556
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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Outlook 2010 toolbar 5 63
Creating a Licensed Office Add-In for Excel 13 255
How can I listen to my e-books on my laptop? 6 119
Inventory Pipeline Production Line Excel Simulation 17 137
I recently resolved a client's Office 2013 installation problem and wanted to offer an observation that may help you with troubleshooting similar issues. The client ordered three Dell Optiplex system units with the Windows 7 downgrade option inst…
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question