I'm coming from a MS SQL Server background, where I would just create a job and import for this, and I'd be all set. I don't know MySQL well at all, so I was hoping someone could point me in the ...

If I do LOAD DATA INFILE and bring it into MySQL, things kind of work, but all of my data has spaces between every character, and a bunch of the fields are not importing correctly (integers fail ...