MySQL Forums :: Newbie :: LOAD DATA INFILE date format hell

Hello all

I am trying to import a csv file into mysql that has a date field.
I have got most of it to import but there is a problem importing the date field, the date in the csv file is formatted like this 01-Jan-2007.

I need to change the date format to 01/01/2007 or 01/01/07 in the load data infile query. How do I do this?

Any help on this matter would be appreciated.

Many Thanks in advance

Gary Thomas