Experts, I am importing from excel. The field "Deliverable" in my Access table is formatted as a memo field but it still doesnt hold all of the text from the imported excel file with the column name "Deliverable". The "Deliverable"column in excel is formatted as text and you can see from the below pic, the matching field "Deliverable" in the Access table is formatted as Memo and I would think it would accept all the text.
why is the field in my access table "Deliverable" not accepting all the text? I think its being cut off at 256 and that is the limit for Text. Memo should be unlimited. The text in the excel column "Deliverable" is not too much more than 256 (probably a max of no more than 500) so I dont think I am running into some type of limit for Memo (if there is one).
fyi I have deleted the field and added it and deleted the table and recreated it but it still doesnt import all the text.
let me know if you see something wrong with the pic or have any other suggestions.