This discussion is locked
userremoved

Q: exporting AppleWorks database to PC

I am a membership secretary for a community org, and have worked hard to create a useful member database on AppleWorks 6. Now I need to resign. When a successor volunteers he/she will probably have a PC, not an Apple. (sad face)

What software do they need to allow me simply to transfer the database to their computer?

MacBook   Mac OS X (10.4.7)   AppleWorks 6

MacBook, Mac OS X (10.4.7), AppleWorks 6

Posted on Mar 22, 2015 11:11 AM

Close

Q: exporting AppleWorks database to PC

  • All replies
  • Helpful answers

  • by Brie Fly,Helpful

    Brie Fly Brie Fly Sep 21, 2006 7:23 AM in response to userremoved
    Level 5 (7,925 points)
    Sep 21, 2006 7:23 AM in response to userremoved
    Save an ASCII Text (pop-up menu in the "Save As..." dialog) copy of your entire database, and give that to the new membership secretary.
  • by userremoved,

    userremoved userremoved Mar 22, 2015 11:11 AM in response to Brie Fly
    Level 1 (0 points)
    Mar 22, 2015 11:11 AM in response to Brie Fly
    That's very helpful, but it seems to be an answer to "how do I export the data in the database", but not to "how do I export the database, structure and all"?

    wee dovit
  • by KOENIG Yvan,Helpful

    KOENIG Yvan Sep 21, 2006 10:27 AM in response to userremoved
    Level 8 (41,790 points)
    Sep 21, 2006 10:27 AM in response to userremoved
    Hello

    There is only one app able to reuse an AppleWorks database under Windows, it's AppleWorks for Windows.
    Alas, this app is only available in the education area.

    Yvan KOENIG (from FRANCE jeudi 21 septembre 2006 19:26:58)
  • by Peggy,

    Peggy Peggy Sep 21, 2006 11:24 AM in response to userremoved
    Level 8 (38,720 points)
    Applications
    Sep 21, 2006 11:24 AM in response to userremoved
    It is highly unlikely that a PC user will be using a database. Almost every PC user uses Excel as a database as well as a spreadsheet. There really isn't any "structure & all" to it. ASCII text will separate each field in the database by tabs & each record by a return. It will not retain any field labels. This can be opened or imported by any spreadsheet or database. You can test this for yourself by opening the saved ASCII text file as a spreadsheet in AppleWorks.

    Some PC users will use Microsoft Works which does have a database. MSWorks can also open or import your ASCII text file in its database or spreadsheet modules. The only way to retain field labels in transfering a database to another program would be to save the database as a DBF. AppleWorks 6 can't save as DBF. If you have a Mac that can use Classic and you have AppleWorks 5 you can save the AppleWorks 6 database as AppleWorks 5, open it in AppleWorks 5 & then Save As… DBF in AppleWorks 5.

    When saving any "foreign" file format from AppleWorks, either 5 or 6, you will have to add the appropriate 3-letter file extension to the file name. AppleWorks won't do it for you. Use .txt for ASCII or plain text or .dbf for the DBF files.

  • by userremoved,

    userremoved userremoved Mar 22, 2015 11:11 AM in response to KOENIG Yvan
    Level 1 (0 points)
    Mar 22, 2015 11:11 AM in response to KOENIG Yvan
    merci, Yvan. Les 3 réponses me suffirent, je crois.

    petit david
  • by userremoved,

    userremoved userremoved Mar 22, 2015 11:11 AM in response to Peggy
    Level 1 (0 points)
    Mar 22, 2015 11:11 AM in response to Peggy
    Thanks Peggy. That's all the info I needed.

    Problem solved.

    wee dovit