(Msg. 1) Posted: Thu Jul 24, 2008 12:13 pm
Post subject: Date Input Mask Add to elertz Archived from groups: microsoft>public>access>gettingstarted (more info?)
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.
(Msg. 2) Posted: Thu Jul 24, 2008 12:16 pm
Post subject: RE: Date Input Mask Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
> 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.
(Msg. 3) Posted: Thu Jul 24, 2008 2:54 pm
Post subject: Re: Date Input Mask Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
>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:
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office Other