It sounds like your dates are probably formatted as Text in Excel, which is why they are also Text when they get to Access.Can someone please help me. I imported data into access from excel and one of the fields in the new table has date as for example Jul-13 as a text format. Is there a way to convert to normal date?