I have an access database (2013 .accdb) with a column containing URLs. This field uses the hyperlink data type in access. I made an OLE connection to the database in ArcMap 10.3.1 but the URLs come in as BLOBs, which I understand Arc does if the data type length is over 255. Is there another data type I should use? Is there another work around? I want my URLs to display in the attribute table. So far I have tried to convert the datatype to Short Text in Access, but this adds a # to the beginning and end of the URL which makes it less simple to copy paste the URL.