import text file date field

[Guest]

Hi Group

I have a .txt file that has a date field. When I use the TransferText w/ spec file or the Import wizard the field I define as Date/Time does not import, instead I get Type Conversion Failure error. I can import the data if I call it TEXT or DOUBLE, LONG INT, etc. I have total control over how the data is formatted in the .txt file. What format should the date field be to import correctly into Access 2002 using TransferText and Spec file? I've tried TEXT & NUM yyyymmdd, TEXT & NUM mmddyy, TEXT & NUM yymmdd, TEXT & NUM mmddyyyy. This seems so straight forward, what am I missing

Thanks
Amy

 

[Alex Ivanov]

mm/dd/yyyy?

--
Please reply to NG only. The email address is not monitored.

Alex.

Hi Group,

I have a .txt file that has a date field. When I use the TransferText w/

spec file or the Import wizard the field I define as Date/Time does not
import, instead I get Type Conversion Failure error. I can import the data
if I call it TEXT or DOUBLE, LONG INT, etc. I have total control over how
the data is formatted in the .txt file. What format should the date field
be to import correctly into Access 2002 using TransferText and Spec file?
I've tried TEXT & NUM yyyymmdd, TEXT & NUM mmddyy, TEXT & NUM yymmdd, TEXT &
NUM mmddyyyy. This seems so straight forward, what am I missing?

 

[Guest]

Thank you so much. I'll just hard code the format in my data, duh! I didn't think Access could handle the extra characters in the Date/Time format, but it's fixed my problem
Thanks, again!