OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

MS Works with OpenOffice

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> General Discussion
View previous topic :: View next topic  
Author Message
Mike In Hope
Newbie
Newbie


Joined: 03 Mar 2007
Posts: 1

PostPosted: Sat Mar 03, 2007 2:38 am    Post subject: MS Works with OpenOffice Reply with quote

Can I import or convert data bases and spreadsheets produced in Microsoft Works V4
to work with OpenOffice?
I've tried to do this but OpenOffice does not seem to have a filter to allow MS Works data files to be converted to use with OpenOffice.
Back to top
View user's profile Send private message
hol.sten
Super User
Super User


Joined: 14 Nov 2004
Posts: 3533
Location: Hamburg, Germany

PostPosted: Sat Mar 03, 2007 2:59 am    Post subject: Re: MS Works with OpenOffice Reply with quote

Mike In Hope wrote:
Can I import or convert data bases and spreadsheets produced in Microsoft Works V4
to work with OpenOffice?
I've tried to do this but OpenOffice does not seem to have a filter to allow MS Works data files to be converted to use with OpenOffice.

Similar questions have been asked over and over again:
- http://www.oooforum.org/forum/viewtopic.phtml?t=53339&highlight=works+import
- http://www.oooforum.org/forum/viewtopic.phtml?t=32779&highlight=works+import
- http://www.oooforum.org/forum/viewtopic.phtml?t=21448&highlight=works+import
and many more. Try the Search of this forum.

Regards
hol.sten
Back to top
View user's profile Send private message
Arineckaig
OOo Advocate
OOo Advocate


Joined: 01 Mar 2004
Posts: 358

PostPosted: Sun Mar 04, 2007 4:44 am    Post subject: Reply with quote

Provided you still have your Works program you can save its spreadsheet files as Excel - then open the Excel file with Calc and most of your formulae will transfer.If you do not have your Works program, you can still select all and copy the Works spreadsheet and then paste the data into Calc: you will, however, lose the formulae.

In the case of Works Database files you need to open in list view (Shft+f9), select all (Ctrl+A), copy and paste into a new OpenOffice Calc file. You will then need to insert a new top row and type in the field names that will not have been copied across. Once the data is in a Calc file it can be taken over to Base. See http://www.oooforum.org/forum/viewtopic.phtml?t=53049&highlight=
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> General Discussion All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group