Re: LOAD DATA

[Devart Team]

To parse '01/01/01' you could use SET clause and STR_TO_DATE function -

LOAD DATA INFILE 'file.txt'
INTO TABLE t1
(column1, @var1)
SET date_field = STR_TO_DATE(@var1, '%d/%m/%y'); format van be changed

Also, have a look at Data Import tool (direct Excel reading).

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/