I have a an ASCII file that I want to load into a table(I am comfortable with this).

The problem is that the date field in my ASCII file is stored as DDMMYYYY and I know that the default date format for MySQL is YYYY-MM-DD.

Once I load the data in, I don't care if it is stored as the default format but how can I get the data to initially load in?