fail to open CSV

[clt_cabq]

I am trying to open a CSV with 93 records and 11 columns but am getting this error.. any ideas what could be causing this?

[Ed_]

May be try converting the CSV to an Excel Worksheet, check the column(s) datatype and then use the tool 'Table to Excel'. 

[RobertBorchert]

it means you have an integer field that is way to long.  

Create a table and use the .csv to fill in the attribute names.  Change the integer field to a string with a length of 255.  Make sure none of the  field has a length of 8000.  All need to be 255 or less

then load it using Load Data

[clt_cabq]

@RobertBorchert that isn't the case here, which is about what I had thought it was initially but some other research pointed to this article and information about some settings (as described in my response to @Ed_ ) . Situation is resolved now, but thanks for your suggestion!

[clt_cabq · Accepted solution]

Update: situation resolved - this article points to some changes at v3.2 that change how Pro handles tabular/text file data and points to settings that should be changed via the Options page. Took me a couple of tries, and the fix finally took when I removed the .csv file from my project and then added it back in again, which is a little bizarre but ArcGIS be like that sometimes.

[Ed_]

As a side note, when I work with CSVs I usually bring it in as a Geodatabase table using the Table to Geodatabase tool I usually avoid bringing in CSVs as is using Add Data

[RobertBorchert]

good info I will have to check my settings.  Have not imported a csv since I upgraded