Convert text to date.

[eddie saidani]

Hi all

I am trying to import a table form a text file (tab delimited) into MySql. I am unable to convert the date fields into a it into the correct mysql date format.

The text file was exported form Excel, the original column format in Excel is: m/dd/yyyy

When I import it as mysql date i get: 0000-00-00 for all the fields,

Can I add a statement when importing the txt file.
Or do I have to import it as Vchar then convert it, if so how would I do that :-)

Thanks.