I have an excel sheet using Office 2010, it has both Date and Time fields . The Time field is formatted in medium time. ie: 9:57A.

I have a table in Access 2010 that I linked to the Excel sheet. When I view the time field in Access table "Time field" it is defined as Text, so the time field can not be sorted. The Date field links properly as Date,

How can I get the linked "Time field" to represent a "Time field" in Access table?



much thanks
dj