LOAD DATA LOCAL INFILE 'C:/path/date.txt'
INTO TABLE dimdate
FIELDS TERMINATED BY ','
LINES TERMINATED BY 'n'
(date_id, yyyymmdd, fulldate, weekofyear, month, quarter, year);