Date Input Mask

[SITCFanTN]

I'm importing a large txt file into my table. The dates in the text file are
YYMMDD, for example 080615 or 080602. When I import the text file into my
table the date is dropped. I've used various imput masks in my table but the
dates are importing, can somebody help me with what the imput mask should be.
I've also used nothing and the data still didn't import. Thanks so much.

 

[boblarson]

Input masks have nothing to do with imports. They are for manual entry.
Your "dates" are not being recognized as dates. You might consider importing
as Text and then use an update query to move them to an actual date field.
--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[John W. Vinson/MVP]

I'm importing a large txt file into my table. The dates in the text file are
YYMMDD, for example 080615 or 080602. When I import the text file into my
table the date is dropped. I've used various imput masks in my table but the
dates are importing, can somebody help me with what the imput mask should be.
I've also used nothing and the data still didn't import. Thanks so much.

Bob's on the money: this field isn't being recognized as a date.

I'd suggest linking to the text field (File... Get External Data...
Link) rather than importing it, and running an Append query. You can
convert the value to a date/time by appending a calculated field:

DateSerial(Left([textdate], 2), Mid([textdate], 3, 2),
Right([textdate], 2))