Format all dates in the data file as a normal date such as 01/01/2002 and reimport.

For fields already formatted as dates in Excel, change the format to 01/01/2002:

1. Right-click on the column header (A, B, C, etc.) and select Format Cells
2. On the Number tab, select Date for the Category and select the appropriate format