Convert Excel Serial Date format to Access Date format?

[DocNice]

I have a spreadsheet in Excel, which automatically converted all of my text dates to serial dates (01/01/2001 to 36526) and stores the information this way reguardless of how I format it. I am trying to import this into Access and it won't recognize my dates as being dates.

How can I get this to be a Date/Time field in Access?

 

[The_Doc_Man]

Please be careful about double-posting.

 

[DocNice]

Sorry about that. I wasn't getting a resposne after several minutes, so I hit "Stop" and retried.