I have spent many, many hours on this problem.
I have over 4,000 records in an MS Works database file (2008 version). One field contains lengthy notes in unformated text. That field is often a few paragraphs long - hundreds if not thousands of characters long. I know Access has a Memo field type that could recieve the long text. However, all techniques I found or tried for conversion only move the text data in Works to a 256 character field in Access. Thus most of the data is lost.
Does anyone have any suggestions?