?
Solved

Opening/converting a .wks file

Posted on 2001-07-20
6
Medium Priority
?
985 Views
Last Modified: 2007-11-27
I have a .wks file that is not readable when I import or open with Excel or Access, but shows a simple table when I view it with Quick View.  The data is somehow there, but I am unable to open it for copying or printing.  Any suggestions for software to view and edit, or for making the file conversion to Excel?

p.s.  I have MS Office 2000, so it not because my apps are older.
0
Comment
Question by:pbowne
[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
6 Comments
 
LVL 8

Expert Comment

by:tskelly082598
ID: 6302642
The file converters to open the Lotus files in Excel are probably not installed by default, unless you specifically chose them with the custom installation.

You should be able to install them by clicking on the  Start button, Settings, and then click Control Panel,
Double-click the Add/Remove Programs icon, and then of the click Microsoft Office 2000 on the Install/Uninstall tab, and then click Add/Remove. There should be a choice for file converters.
0
 
LVL 49

Expert Comment

by:dbrunton
ID: 6303676
You could also try using Word to import it.

Or go to someone else's machine with Office and try using their Excel to convert it.  You may also be able to pick up a copy of Lotus for around $20 to open it for you.
0
 

Author Comment

by:pbowne
ID: 6305053
To tskelly:  I do have the Lotus file converters installed in my Office 2000, and I am still unable to open the file in a version that is editable.

To dbrunton:  I have tried using Word to import it and I get the same results as using Excel.  If it comes down to me buying a copy of Lotus, I would rather make the person sending it buy a copy of Office!

Any other suggestions?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 8

Accepted Solution

by:
tskelly082598 earned 400 total points
ID: 6306075
It would help to know which version of Lotus 123 was used to create the file, or if instead, it was created as a .wks file by some other program.

I found a program, 123toasc.zip, said to convert 123 to ASCII converter.

http://www.cyf-kr.edu.pl/mirr-html/simtel/simtel_spredsht.html
0
 

Author Comment

by:pbowne
ID: 6306307
I don't know which version of Lotus 1-2-3 was used (or if it was Lotus 1-2-3).  However, using the program you noted and another at the same URL which reads .wks and .wk1 files, I was able to find out that there are some errors in the file, and yet I was still able to get most of the info.  

Thanks!
0
 
LVL 8

Expert Comment

by:tskelly082598
ID: 6307903
You're welcome. Glad they worked.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
This article was originally published on Monitis Blog, you can check it here . If you have responsibility for software in production, I bet you’d like to know more about it. I don’t mean that you’d like an extra peek into the bowels of the sourc…
This video demonstrates basic masking and how to edit the mask to reveal the desired image.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

752 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