Importing Date/Time - Easy one I think!!

[ACE]

Hi, I am trying to import a txt file into Access. It all works fine except for the Time column won't import. It's separate from the Date column. I classified it as Date/Time but it won't import. There is a.m. and p.m. at the end of each time. Does that mean that I have to import it as text or is there someway that you can set it up to recognize the am and pm. Thanks!!!

 

[Pat Hartman]

If it is adjacent to the date field, import the two of them as one field. If that doesn't work, the problem may be the non-standard time format. I think Access expects AM or PM but not the periods. If that is the case, you'll need to import the field as text and then run an update query to fix its format so that Access will recognize it as a time value. Then you can add it to the already stored date field. And I do mean ADD in the arithmetic sense.

YourDateField + ReformattedTime

 

[ACE]

How do you import it as one field? It was a comma delimeted file. There are no periods so it should work as is.

 

[Pat Hartman]

If the file is coma delimited, you need to treat the time as a separate field for import but since it is non-standard format, you'll need to import it to a text field and then run the update query to reformat it and add it to the date field.