How do I import Times such as 23:47:43.56 in Access 2003?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have numerous (hundreds of thousands) of records in Excel that include a
Time field that includes hundreths of seconds. I cannot get it to import into
Access unless I strip off the hundreths part, which I would like to keep, if
possible. I see nothing in my manuals on how to do this.
 
If you try to import to a date/time field in Access, you'll be limited to
what an Access date/time field can store.

Or you could import the literal strings from Excel into a text field in
Access, and work out your parsing routines.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Have you checked the underlying values that are imported? As far as I
can remember Access stores date/time values at the same resolution as
Excel: it simply doesn't have a built-in way of *displaying* fractions
of a second.
 
Back
Top