I tried with an old AppleWorks (successor of ClarisWorks) database. Saved it as text in AppleWorks 6 in SheepShaver MacOS9. The ascii text file opens nicely in Apple's Numbers with rows and columns intact. It will also open in MS Excel, but it looks better in Numbers. Because the "text" file is ascii text, special characters will not be displayed correctly.RanJay wrote:If I save it as a text file, which I can, is there anyway to import it into a new program that can sort and align the rows/columns?
I do not currently have a database application to try.
I could not make the original database open in LibreOffice as adespoton suggests and CW/AW databases does not have a CSV export option.