import date format from excel

[fanfan2]

im trying to import the attached excel file to access table. I got error message says "type conversion error". the date column after 07/13/2007 can not be imported, but anything before that date can. I formated everything in excel with the same format, how did this happen?

Thanks.

 

[Dennisk]

you default is most probally in UK format i.e. dd/mm/yy but you are importing USA formatted dates i.e. mm/dd/yy hence the error for month 13