I'm importing a table from an .accdb file in Access 2016 into ArcMap 10.6 via an OLE DB connection and one of my nine text fields is importing in BLOB format. It and all the other fields are formatted as short text with a 255 character limit. The longest record in the problem field is ~ 100 characters. I thought ArcMap only used BLOB format for text if it was over 255 characters.
Below is a summary of the structure of the table in the Access database and how it is formatted in ArcMap after it is added by field type and number of fields:
Any suggestions for what I am missing and how I might get ArcMap to recognize this field as a string rather than a BLOB?