Have you tried opening your AppleWorks 6 word processing documents in Pages at all? If you have, have you been getting errors or having other problems? I've not had any problems opening AppleWorks 6 word processing or spreadsheets in Pages & Numbers. Everything looks as it did in AppleWorks only better.
You will have much better luck retaining any formatting of AppleWorks documents by opening them in Pages than you would saving as any other format. Remember that The iWork applications - Keynote, Pages & Numbers - can only open AppleWorks 6 presentation, word processing & spreadsheet documents, respectively. They will not open any other type of AppleWorks 6 files or any AppleWorks 5 or any version of ClarisWorks files.
The third-party application, EazyDraw, can open AppleWorks draw documents. If you still have access to AppleWorks you can copy the contents of draw documents, paste them into an AppleWorks word processing document in object mode (click the arrow in the tool panel), save the WP document & then open it in Pages. You can copy & paste from AppleWorks to Pages but you would have to do it object by object or it will be one big uneditable object.
There is nothing other than AppleWorks that can open paint or 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. Paint documents can be saved as one of many different formats to be opened in most image editing programs. I recommend using PICT for best results.
Yvan Koenig has written a number of AppleScripts that can do batch converting of AppleWorks documents to Pages or Numbers. Check his iDisk for scripts you can download. Start with the "for iWork" folder.
27"/3.4 GHz i7 iMac; 15" unibody MacBook Pro 2.4GHz, Mac OS X 10.6.8
G5 2.3GHz, Mac OS X 10.4.11
iPhone 3GS, iPad 1, 2GB iPod nano, 5G iPod video, 60 GB iPod Photo
AirPort Extreme dual band, G5 iMac, G4/700 iMac, PB 1400, Apple IIgs