MySQL CSV import is filling table with zeroes

I have an a CSV file, 8 columns, numbers and text, and I am trying to import into MySQL. It creates the appropriate number of rows, but fills them with zeroes.

The table has a the same schema as an SQLite table where importing directly worked correctly.

I cannot determine why it is filling with zeroes, the data types match up correctly.

The schema:

+------------------+--------------+------+-----+---------+-------+
| Field            | Type         | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| id_AccountNumber | int(11)      | NO   |     | NULL    |       |
| Check_Number     | int(11)      | NO   |     | NULL    |       |
| Date             | date         | NO   |     | NULL    |       |
| Source 2         | varchar(100) | NO   |     | NULL    |       |
| Amount           | double(8,2)  | NO   |     | NULL    |       |
| Type             | varchar(255) | NO   |     | NULL    |       |
| PostingCode      | int(11)      | NO   |     | NULL    |       |
| Source           | varchar(255) | NO   |     | NULL    |       |
+------------------+--------------+------+-----+---------+-------+