Importing Date/Time - Easy one I think!!

ACE

Registered User.
Local time
Today, 11:39
Joined
Aug 21, 2003
Messages
18
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!!!
 
How do you import it as one field? It was a comma delimeted file. There are no periods so it should work as is.
 

Users who are viewing this thread

Back
Top Bottom