> LOAD DATA LOCAL INFILE '/tmp/testdata.txt' INTO TABLE testtable FIELDS TERMINATED BY '\t';

> LOAD DATA LOCAL INFILE '/tmp/VICIDB/matltran.txt' INTO TABLE matltran FIELDS TERMINATED BY '\t' FIELDS OPTIONALLY ENCLOSED BY '"';

Fields are tab delimited and need to match table schema. 
I've found the tab separator  ASCII(009)  preferable over using a comma.

The second version can help remove double quotation marks around character fields. 

Don't forget the keyword LOCAL.

Import data from tab - delimited datafile to SQL table.

sql, table, data, load

SQL