Is there a way to change Table to Table import parameters in ArcCatalog to either import text longer then 255 characters or truncate the input text to 255 characters?
I have 350 tables in a CSV format and I am using import Table (multiple) function in ArcCatalog. Majority of the table import fine but some fail because the source field text is longer then 255 characters. Instead of making the text field longer automatically ArcCatalog importer fails with the following error (identical in all cases):
Failed to convert C:\Users\Jakub Sisak\Desktop\LIDS_Jan2013\Processed_TBL\arasurpt_ara_survey_point.csv. ERROR 001156: Failed on input OID -1, could not write value 'Area upstream of culvert appears to have been ponded recently, possibly due to culvert blockage/beaver activity. Sampling started upstream of ponded area. Only fish sampling was done. Station UTM is downstream end. Pond at upstream is man-made dam of earth and debris and is in poor repair.' to output field COMMENTS Failed to execute (CopyRows).
Is there a way to change the "importer" paramaters to either truncate the string (accaptable) or increase the length of the text field (ideal)
I am using File Geodatabase, ArcGIS Standard (ArcEditor). There is no memo field option in FGDB but text field (default length 255 characters) can be more then 255.