I'm trying to use LOAD DATA INFILE to get .txt file data into my table.
I have a field named acreage in my table and it is type "int"
Below are some examples of the acreage data contained in the .txt file.
when I try to insert the data I get "Incorrect integer value" error.
I tried a couple different things like setting the field to decimal 8,2 but still get the same error. I can insert the data if the field is set to varchar, but I need to be able to use this field in a numeric search.
Any help greatly appreciated!