Data truncation Error in Uploading database to Access?

This error can be solved by

1. making all the data type field as text
2. if the problem persists, see the error column in which truncation occur and set the datatype as MEMO