In a recent reply to a question regarding moving an AppleWorks database to another application I mentioned that there was no direct way to export that data and maintain the original layout. The experts seem to concur. A number of readers got in touch—both via email and in Macworld’s Mac 911 forum —to recommend the best way to export an AppleWorks database.
1. Open the AppleWorks database and choose Organize: Show All Records.
2. Select a layout that displays every field, select all, and copy the text to the clipboard.
You can also export the database as ASCII text, but if you export the database data to an AppleWorks spreadsheet and then move it to FileMaker, some odd characters might appear.
2. Open a new spreadsheet document.
This can be AppleWorks’s own spreadsheet component or an Excel document.
3. Paste the text into the spreadsheet.
In all likelihood your data won’t contain field headings—Address and Phone Number, for example. When pasting your text, be sure to plunk that text a couple of rows down, leaving room to enter the field heading titles in the first row of the spreadsheet.
4. Save the spreadsheet as ASCII text.
5. Open that file in FileMaker Pro.
The data will appear in a spreadsheet layout, meaning that you’ll have to recreate the original database’s layout.
Optionally, if you’re simply looking for a way to search for existing data and plan to start fresh in FileMaker, feel free to leave the data in a spreadsheet, which you can easily search.