944,047 Members | Top Members by Rank

Jun 28th, 2006
0

change data from ms works db into spreadsheet

Expand Post »
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:
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
friedolin is offline Offline
3 posts
since Jun 2006
Jun 28th, 2006
0

Re: change data from ms works db into spreadsheet

Quote 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.
pty
Reputation Points: 64
Solved Threads: 39
Posting Pro
pty is offline Offline
530 posts
since Oct 2005
Jun 28th, 2006
0

Re: change data from ms works db into spreadsheet

Quote 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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
friedolin is offline Offline
3 posts
since Jun 2006
Jul 4th, 2006
0

Re: change data from ms works db into spreadsheet

Quote 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
Featured Poster
Reputation Points: 1448
Solved Threads: 21
Posting Maven
GrimJack is offline Offline
2,735 posts
since Feb 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Windows Software Forum Timeline: correct time mail
Next Thread in Windows Software Forum Timeline: Windows Media Player 10 no sound





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC