How to overcome 254 character limit importing CSV or excel files?
I have a table, I need import CSV with a few columns that are about 1000 characters long, maybe creating 4 fields for each, but how to split them?
isn't it a feature already as the csvprocessor creates a cursor or dbf with multiple fields for a csv column if values in the csv columns are longer than 254 chars?
isn't it a feature already as the csvprocessor creates a cursor or dbf with multiple fields for a csv column if values in the csv columns are longer than 254 chars?
Not quite. Columns larger than 254 characters are treated as memo fields. One column, one field. What the CSVProcessor does is create several cursors when there are more than 254 columns in the CSV source data.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.