Windows Software

change data from ms works db into spreadsheet

•

Join Date: Jun 2006

Posts: 3

Reputation: friedolin is an unknown quantity at this point

Solved Threads: 0

friedolin

Offline

Newbie Poster

change data from ms works db into spreadsheet

Jun 28th, 2006

Hello, is the savior of my work out there?? Problem: How can I transfer data /names from a database works (horizontally) into a spreadsheet (vertically) in order to sort the names A-Z ?? I am a teacher and need to do this very often... but????:rolleyes:
I have ms works 6.0 and as well windows 98 and also windows 2000.
No help in sight from the HELP!! button :-|
Thanks if someone can help me!!
friedolin:lol:

•

Join Date: Oct 2005

Posts: 523

Reputation: pty is on a distinguished road

Solved Threads: 37

pty

Offline

Posting Pro

Re: change data from ms works db into spreadsheet

Jun 28th, 2006

•

Originally Posted by friedolin

Hello, is the savior of my work out there?? Problem: How can I transfer data /names from a database works (horizontally) into a spreadsheet (vertically) in order to sort the names A-Z ?? I am a teacher and need to do this very often... but????:rolleyes:
I have ms works 6.0 and as well windows 98 and also windows 2000.
No help in sight from the HELP!! button :-|
Thanks if someone can help me!!
friedolin:lol:

Didn't know MS Works had a database.

If you open your database and click 'file', are there any 'export' options available?

Alternatively, if you click 'file'->'save as' can you select a file format? If you can, try saving it as .xls (or whatever the MS Works Spreadsheet file extension is)

Last edited by pty; Jun 28th, 2006 at 3:58 pm.

•

Join Date: Jun 2006

Posts: 3

Reputation: friedolin is an unknown quantity at this point

Solved Threads: 0

friedolin

Offline

Newbie Poster

Re: change data from ms works db into spreadsheet

Jun 28th, 2006

•

Originally Posted by pty

Didn't know MS Works had a database.

If you open your database and click 'file', are there any 'export' options available?

Alternatively, if you click 'file'->'save as' can you select a file format? If you can, try saving it as .xls (or whatever the MS Works Spreadsheet file extension is)

Thanks for the hint, but no export versions and only file as dtbIV and older works formats. The problem is that the database is wonderful to have lists and individual reportsheet side by side, but I'd like to sort them differently und also calculate and WDB is not very versatile.
The general question is :"how do I transport info from horizontal cells into vertical cells,.. thats all! it MUST be possible??
friedolin

•

Join Date: Feb 2004

Posts: 2,222

Reputation: GrimJack will become famous soon enough

Solved Threads: 16

GrimJack

Offline

Nearly a Posting Maven

Re: change data from ms works db into spreadsheet

Jul 4th, 2006

•

Originally Posted by friedolin

Thanks for the hint, but no export versions and only file as dtbIV and older works formats. The problem is that the database is wonderful to have lists and individual reportsheet side by side, but I'd like to sort them differently und also calculate and WDB is not very versatile.
The general question is :"how do I transport info from horizontal cells into vertical cells,.. thats all! it MUST be possible??
friedolin

Heh,heh - I just reloaded MSWorks to see what you were on about -- yep, there are some interesting decisions made on what to let users play with. Let me see if I understand - you have MSWorks and built a database with the names you want to sort as field/column names? and now want them as row names so you can sort them. I have Works v8 and can 'save as' .wsb, .csv, .txt. .dbf. csv and tst files can be imported into excel - if you do not have excel then try installing OpenOffice (http://www.openoffice.org/). As far as I know, this program will import most if not all of the extensions. Once there you can do pivot tables and so on. The open office stuff is open along the lines Linux and other *nix open source programs. It should not be very difficult to pick as it is juat another program like all the others., If you have any more questions, please ask - I could load OpenOffice and fudge around

Imagine a world without hypotheticals....
You can have my book when you pry it from my cold, dead fingers.