iDatabase can import data from text files, including comma-separated value (CSV), semicolon-separated value as well as tab-delimited. Apple Works can export text files using the ’ASCII’ option. The extension of the exported file needs to be changed to .csv in order to be visible to iDatabase. To obtain the desired result you must adjust the importing settings of iDatabase in the Import Window. This is facilitated by a live preview.


Note: you can automatically import text fields only, for other types of fields, you must do it manually. After importing, go to the "Define" section of the app, and create the missing fields, then scroll through the records and manually add the missing information.


Related solutions:

How to adjust the settings of the Import Window of iDatabase for Mac?