| View previous topic :: View next topic |
| Author |
Message |
Mike In Hope
Newbie
Joined: 03 Mar 2007
Posts: 1
|
 Posted: Sat Mar 03, 2007 2:38 am Post subject: MS Works with OpenOffice |
 |
|
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 |
|
 |
hol.sten
Super User
Joined: 14 Nov 2004
Posts: 3532
Location: Hamburg, Germany
|
|
| Back to top |
|
|
Arineckaig
OOo Advocate
Joined: 01 Mar 2004
Posts: 332
|
| Posted: Sun Mar 04, 2007 4:44 am Post subject: |
|
|
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 |
|
|
|
