Date/Time Between Excel and Access 1

[jake1016]

I have some data that is available to me in Excel that I want to store in Access. One of the data elements is a race time that looks like this in Excel: 01:56.1 (indicating that the time of the race was 1 min 56 sec and 1/5 sec). To get it to display like this I format the cell like this: mm:ss.0

I want to replicate this in Access when I look at the table view. the only thing I can do is mm:ss I can't see how to do the fraction of a second piece.

Does anyone know what I'm missing?

Thanks.

 

[Darrylles]

Hi jake,

MS Access only stores hh:mm:ss, so when you import the Excel field into Access - it strips the :ms portion.

The workaround will be to store this time field in an MS Access text field, and then extract what you need using VBA string manipulation.

Sorry - a bit more work for you.

ATB

Darrylle





Never argue with an idiot, he'll bring you down to his level - then beat you with experience.