James Glynn
Level 1 (12 points)
Mac OS X

Q: What can replace Appleworks database?

My non-profit business database has been on Appleworks forever! Mainly that means names and addresses and record of monthly contributions, from which I send a mail merge letter of acknowledgement to contributors each month. Now I have read that Appleworks will not work on Lion. If I understand correctly, Bento can’t do mail merge with auto fill-in of addresses and other personalized info. So what can I transfer all this info to? And HOW will I transfer years of records on my Appleworks database?

iMac Intel, Mac OS X (10.5.2)

Posted on Jul 7, 2011 6:50 PM

by Roger Wilmut1,Solvedanswer
Roger Wilmut1 Roger Wilmut1
Level 9 (78,576 points)
iTunes
A:

The only program with anything like the functionality of the AppleWorks database is FileMaker Pro. It's expensive, and has a steep learning curve, but can do almost anything the AW database can plus a good deal more. It's also pretty well the industry standard so it's not likely to go away.

 

However it can't import AW dateabases; you have to export them as ASCII text and import that, which means you will have to recreate layouts and calculation fields.

 

Please see this page:;

 

http://www.wilmut.webspace.virginmedia.com/notes/aw/page6.html

Posted on Jul 7, 2011 11:16 PM

Close
James Glynn

Q: What can replace Appleworks database?

  • All replies
  • Helpful answers

  • by K T,Helpful

    K T K T Jul 7, 2011 6:53 PM in response to James Glynn
    Level 7 (23,844 points)
    Publishing
    Jul 7, 2011 6:53 PM in response to James Glynn

    Bite the bullet...export to a generic format, import to Numbers and rework as needed.

     

    Bento is not ready....

  • by Peggy,Helpful

    Peggy Peggy Jul 7, 2011 8:15 PM in response to James Glynn
    Level 8 (38,954 points)
    Applications
    Jul 7, 2011 8:15 PM in response to James Glynn

    There is nothing other than AppleWorks that can open AppleWorks database documents. Database data can be copied & pasted into an AppleWorks spreadsheet, saved & opened in Numbers or saved as ASCII/plain text & opened in most any spreadsheet, database or word processing program.

     

    I've converted almost all of my AppleWorks databases to Numbers spreadsheets. There are a couple that I've moved the data but they really need the database. I do have the option of using AppleWorks 6.2.2 for Windows in Parallels but that may not be an option for many users.

     

  • by Roger Wilmut1,Solvedanswer

    Roger Wilmut1 Roger Wilmut1 Jul 7, 2011 11:16 PM in response to James Glynn
    Level 9 (78,576 points)
    iTunes
    Jul 7, 2011 11:16 PM in response to James Glynn

    The only program with anything like the functionality of the AppleWorks database is FileMaker Pro. It's expensive, and has a steep learning curve, but can do almost anything the AW database can plus a good deal more. It's also pretty well the industry standard so it's not likely to go away.

     

    However it can't import AW dateabases; you have to export them as ASCII text and import that, which means you will have to recreate layouts and calculation fields.

     

    Please see this page:;

     

    http://www.wilmut.webspace.virginmedia.com/notes/aw/page6.html

  • by John Franz,

    John Franz John Franz Jul 22, 2011 5:55 AM in response to Roger Wilmut1
    Level 1 (129 points)
    iTunes
    Jul 22, 2011 5:55 AM in response to Roger Wilmut1

    Filemaker is expensive. Is the $299 version acceptable?