text cvs to date format

[Stacey]

I have a file which I will be uploading into Access on a regular basis. The
date field is formatted to text which I would like to format into a date
field upon importing into Access. I would also like to rearrange the date
into a regular format, it reads as such 082101 and I would like it to read
01/21/08. Any help is greatly appreciated. Thanks in advance!

Stacey.

 

[Pat Hartman]

Posting the same question every half hour is not a good way to make friends
here or on any forum.

 

[Stacey]

Forum - please disregard this question. Thanks!

Posting the same question every half hour is not a good way to make friends
here or on any forum.

 

[cc]

slt