Problem importing from CSV

[KGee]

I keep receiving a "type conversion failure" when importing data from a CSV file to an existing table. The field is setup as a number (long integer) in my table and I have verified there are only numbers in that field for the file I am importing but it fails for each record. All other number fields import without issue. Am I overlooking something obvious? I do need this field to be numeric so I don't want to flag as a text field.

 

[KGee]

When I import the same file into a new table, all of the data for the field imports without a problem but I then receive random conversion failures on other fields. I don't understand why.

 

[KGee]

User error on this one. Was forgetting to set the text qualifier during the import.