Date Conversions

[Adam]

I am importing a raw data file, fixed width. There is a
date field in the text file that looks like:

031014

YYMMDD is the format.

When I put Date/Time format in the Access table it errors
out due to conversion type failure. How can I make Access
understand this?

Thanks

 

[Bruce M. Thompson]

I am importing a raw data file, fixed width. There is a

date field in the text file that looks like:

031014

YYMMDD is the format.

When I put Date/Time format in the Access table it errors
out due to conversion type failure. How can I make Access
understand this?

Use the DateSerial() function:

DateSerial(left([DateValue],2),mid([DateValue],3,2),right([DateValue],2))

"DateValue" would be the name of the field that you are converting.