Help I am lost!

I imported a csv file into Excel then into Access with one column of dates.
In the csv file the dates are just numbers, I am assuming they are cereal
numbers for the dates?? How do I get them back to dates in access? I
imported first to Excel and tried to format them as dates but they remain
numbers. Then imported them to Access. In access I can not get them to
convert to dates either. LOST.

Thanks,
Jerry

Have you tried CDate(number)

? CDate(38967)
9/7/2006
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Jerry Kinder" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Help I am lost!
>
> I imported a csv file into Excel then into Access with one column of
> dates.
> In the csv file the dates are just numbers, I am assuming they are cereal
> numbers for the dates?? How do I get them back to dates in access? I
> imported first to Excel and tried to format them as dates but they remain
> numbers. Then imported them to Access. In access I can not get them to
> convert to dates either. LOST.
>
> Thanks,
> Jerry
>
>