CSV text into Date field

S

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.
 
P

Pat Hartman

Do the import again ONCE manually and create an Import Spec and save it.
This will allow you to specify the format of the input date so that Access
knows how to convert it to a DateTime data type. You would then refer to
this import spec in your code in the TransferText method code.
 
Top