Converting MS Works

Not sure where to post? Post here!

Converting MS Works

Postby Bill1947 » Mon Nov 17, 2008 7:44 pm

Welcome beginner. What is your question or comment?
Please try to briefly and clearly tell us: What you want, What you tried, and What happened.

I have been using ms works for years-and I want to convert my database and spreadsheet files. How do I do this?

Thank you,
Bill (bhowell1980<at>msn.com)
OOo 2.3.X on Ms Windows XP
Bill1947
 
Posts: 23
Joined: Mon Nov 17, 2008 7:30 pm

Re: converting msworks

Postby TheGurkha » Mon Nov 17, 2008 8:03 pm

Hi and welcome to the forums.

OOo does not natively support MSWorks files, but NeoOffice, an OOO 'derivative' does.

But if you still have access tto Works you might be able to open your docs and save them as RTF or CSV or some other format that OOO does know about.

See this thread: Convert MS /Works Database files.
Ubuntu 13.04 Raring ringtail, LibO 4.0.2.2 (Build ID 400m0 (Build:2))
Gurkha Welfare Trust
User avatar
TheGurkha
Moderator
 
Posts: 6426
Joined: Thu Mar 13, 2008 12:13 pm
Location: North Wales, UK.

Re: converting msworks

Postby Arineckaig » Mon Nov 17, 2008 9:30 pm

If you still have your Works program you should have no problem saving a spreadsheet as an Excel file that can then be opened directly by Calc: most formulae will copy across correctly.

In the case of Works database files I have found an alternative to CSV or RTF routes, which is usual safer if you have many records but relatively few fields, is to copy and paste to a Calc file. Open the Works DB file in List View; click the top left corner to select all; copy and paste into the second row of a new OOo Calc file. Usually you can simply click OK on the Text Import dialog, and all the data will appear without errors, but only as text, in the Calc file. The field headings row, however, will not have been copied across, so you will need to type the required field headings into the empty top row. Once you have the data in a Calc spreadsheet it can readily be imported into a OOo Base table.
When this issue has been resolved, it would help other users of the forum if you add the word - [Solved] - to the Subject line of your 1st post (edit button top right).
OOo 3.4.1 on MS Windows XP MySQL and HSQLDB
Arineckaig
Volunteer
 
Posts: 600
Joined: Fri Nov 30, 2007 10:58 am
Location: Scotland

Re: Converting MS Works

Postby Bill1947 » Tue Nov 18, 2008 7:27 pm

Thank you, I willtry these options and let you know how it works. First what are rtf and csv formats?
OOo 2.3.X on Ms Windows XP
Bill1947
 
Posts: 23
Joined: Mon Nov 17, 2008 7:30 pm

Re: Converting MS Works

Postby TheGurkha » Tue Nov 18, 2008 7:31 pm

Bill1947 wrote:Thank you, I willtry these options and let you know how it works. First what are rtf and csv formats?


CSV
RTF
Ubuntu 13.04 Raring ringtail, LibO 4.0.2.2 (Build ID 400m0 (Build:2))
Gurkha Welfare Trust
User avatar
TheGurkha
Moderator
 
Posts: 6426
Joined: Thu Mar 13, 2008 12:13 pm
Location: North Wales, UK.

Re: Converting MS Works

Postby Bill1947 » Wed Nov 26, 2008 7:06 am

Hello all,

Thank you very much for your input. I have decided to just retype all my db's and sprdshts. rather than try to convert my files. I am not bright enough nor patient enough to learn. Once I retype all my files, I believe they can be used in open office or ms office if need be and being retired, I have the time.

Thank you much,
Bill
OOo 2.3.X on Ms Windows XP
Bill1947
 
Posts: 23
Joined: Mon Nov 17, 2008 7:30 pm

Re: Converting MS Works

Postby TheGurkha » Wed Nov 26, 2008 10:45 am

Ok. The basic golden rule is work in the OOo default formats, .odt for text, .ods for spreadhseets etc.

Then when you need to send a copy to someone who doesn't have OOo you can use File > Save As and choose Microsoft Word 97/2000/XP from the Save as type drop down menu to create a copy to send to them. Then go back to your OOo version to carry on working on it.

Or send them a PDF if they just need to read, not edit. OOo has a PDF buttonright there on the toolbar for this.

If you get stuck come back and let us know.
Ubuntu 13.04 Raring ringtail, LibO 4.0.2.2 (Build ID 400m0 (Build:2))
Gurkha Welfare Trust
User avatar
TheGurkha
Moderator
 
Posts: 6426
Joined: Thu Mar 13, 2008 12:13 pm
Location: North Wales, UK.


Return to Beginners

Who is online

Users browsing this forum: No registered users and 17 guests