TA25361: AppleWorks: Restoring Unusable Database Document

Learn about AppleWorks: Restoring Unusable Database Document
deebee070521

Q: I have a ton of documents and databases in AppleWorks v 6.0 that I can no longer open on my MacBook Pro.  Is there any way to recover this info?  Some documents can be opened and resaved with textedit, but not my database with all important addresses.

I have a ton of documents and databases in AppleWorks v 6.0 that I can no longer open on my MacBook Pro.  Is there any way to recover this info?  Some documents can be opened and resaved with textedit, but not my database with all important addresses.

Posted on Aug 29, 2012 6:43 PM

Close

Q: I have a ton of documents and databases in AppleWorks v 6.0 that I can no longer open on my MacBook Pro.  Is there any way to ... more

  • All replies
  • Helpful answers

  • by Shootist007,

    Shootist007 Shootist007 Aug 29, 2012 6:46 PM in response to deebee070521
    Level 6 (16,660 points)
    Aug 29, 2012 6:46 PM in response to deebee070521

    Try TextWrangler.

     

    Oh and not sure about the database files. Maybe open them on your old Mac that stilll has AW and save them in some other format.

  • by Peggy,

    Peggy Peggy Aug 29, 2012 9:22 PM in response to deebee070521
    Level 8 (38,947 points)
    Applications
    Aug 29, 2012 9:22 PM in response to deebee070521

    There is nothing other than AppleWorks that can open AppleWorks or ClarisWorks databases. You will have to have access to a Mac with Snow Leopard or earlier & AppleWorks 6, preferably 6.2.4 or 6.2.9, to open those databases. You will then have to decide whether to export as plain text which will give a tab-delimited file or copy & paste into an AppleWorks spreadsheet. You will lose any calculations & summaries.

     

    I moved all of my newer databases to Numbers by first opening them in list view in AppleWorks, selecting all & copying then pasting into an AppleWorks spreadsheet & saving that. Numbers then opened them without a problem. This also preserved any text formatting.

     

    Peggy_sig.png

  • by Barry,

    Barry Barry Sep 8, 2012 11:28 AM in response to Peggy
    Level 7 (32,721 points)
    iWork
    Sep 8, 2012 11:28 AM in response to Peggy

    I tried Peggy's List > Select All > Copy > Paste into an AW spreadsheet suggestion.

     

    In my case, pasting into the spreadsheet lost all text formatting (mostly text set to bold). The results of formulas were pasted, and checkboxes were pasted as "on" or "off". The DB did not contain any pop-up menus or radio buttons, but I expect they would transfer as a number showing the list position of the chosen item.

     

    Pasting the copied List view data into a Numbers table gave a result similar to that with AppleWorks. I selected B2 as the target cell (for top left cell of the pasted data) to avoid any effects of posting into a header row or column. Bold and regular text formatting looked the same as it had in AW's List view.

     

    Based on that, I'd slip the 'paste into an AppleWorks Spreadsheet step, and paste directly into a Numbers Table.

     

    Regards,

    Barry