How do I convert an Appleworks 5.0 database file to Microsoft Excel
2001 for Mac OS 9.1, using the database fields to fill in rows?

Hi jp12345-ga,

The answer to your question is one that I have come to realize has
been frustrating to most Appleworks users. Simply put, Appleworks does
not have a self-contained translator for converting database
information into Microsoft Excel 2001.

There are, however, a couple of alternatives that have become
available as a result of this overlooked functionality.

Conversion Plus 6.0 (pages 7 & 8)

This program is able to convert between Appleworks and programs
contained in the MS Office Suite (which includes Excel):

General Information:
http://www.dataviz.com/products/conversionsplus/index.html

Product Fact Sheets:
http://download.dataviz.com/pdf/brochures/conversionsplus.pdf

http://download.dataviz.com/pdf/brochures/datavizbrochure.pdf

This product is also able to convert between Mac and PC file formats
in case you are interested in that as well.


Appleworks 6 + MacLinkPlus

MacLinkPlus, a program designed for Appleworks 6, is another option
for providing the missing file translators. A single user license is
$99.95:

http://www.dataviz.com/products/maclinkplus/mlp_evol.html

This link provided offers a discount over the retail price of the
product and also includes an Appleworks manual:

"More serious was in the is the elimination of the XTND file
translators, one of the strongest features of previous
ClarisWorks/AppleWorks versions. AppleWorks 6 has no native ability to
open documents created by other applications save for plain text and
some graphic and music formats translated by QuickTime. Consequently,
AppleWorks 6 users who need to import or export files in, say,
Microsoft Word or Excel formats, are out of luck unless they buy a
copy of DataViz's MacLinkPlus file translation software, which is
actually another good reason for buying AppleWorks 6: The Missing
Manual. Included in the book is a discount coupon that allows you to
purchase MacLinkPlus for $39.95, which is a cool $60 off the program's
list price of $99.95."

http://www.applelinks.com/mooresviews/aw6.shtml

Prices for Appleworks 6 can be viewed courtesy of Pricegrabber.com:
http://www.pricegrabber.com/search_getprod.php/masterid=583836/search=appleworks%206/ut=1850513038e50e11

The idea with this option is that you can upgrade your Appleworks
version, which is able to read Appleworks 5 files. Then, use
MacLinkPlus to convert to Excel format.

I hope that helps...if you have any problems understanding the
information above please feel free to post a clarification and I will
respond promptly :)

Cheers!

answerguru-ga

The researcher was only able to tell me what I already knew about the
capabilities of third party software. I was looking for a way to
convert Appleworks to Excel without the purchase of additional
software. He was able to tell me that there was no such option.