Last things first: The error message from the LOAD DATE INFILE means that your table test was not created correctly.
For some reason, you created the field `Agent Name` as an INT(eger) field when clearly it should be VARCHAR(50) or something like that.
But I don't understand this, at all.
In your post #4 you wrote "This is actually just a .csv file. It is formatted that way just because that is how it is pulled from the database. " So if you pull the CSV file *FROM* the database WHY in the world are you now trying to put it BACK into the dataabase? I don't understand the reasoning behind that, at all.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.