I am using Arcpy to load a table from Excel. One of the fields has a lot of text (up to 2000 characters) and when using arcpy.MakeTableView_management the field is given the type 'BLOB'. Is there any way to either prevent this from happening, i.e. making sure the field type is 'Text', or is there a way of reading the text in python so the data can be used?
I have read BLOB TYPE in Arcmap but it does not answer the question. I am specifically trying to read the data in Python, while the previous question referred to reading it in ArcMap.