I have several .csv files and i'm trying to insert them into a database table.
all my files are saved from an excel spreadsheet - saved as .csv.
I'm trying to import these into a table varchar(50).
All my data in the single field being inserted into the table are only 7 characters long (uk postcodes) but changed to varchar 50 as it was giving me error about the field not being long enough.
Here are 14 screenshots of my table, my data and all my settings: