Import problem with Time format

[Lee Grant]

Hi there,

I'm really new to Access and I'm trying to import a long list from Excel to
Access.

Everything is OK apart from the TIME field. In Excel the cell format is set
to hh.mm.ss.00

This works well I cannot find a format that will display this in Access.
I've tried setting the data-type of the field to date/time and setting the
format to hh.nn.ss.00 but Acess doesn't like it.

Could someone point me in the correct direction?

Kindest Regards,

Lee Grant

 

[John Spencer]

Access does not store times to any finer granularity than seconds. So
you cannot show hundredths of a second in Access.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Lee Grant]

Hi John,

Thanks for that pointer - that could've take some time for me to sort that
one then!!

I'changed the Excel cell format to be hh:mm:ss and I've set the Access field
as date/time and put a custom format on as hh:nn:ss (not bracketed in " ")

All the other data imports fine but these particluar fields are blank.

Could you advise what I could try next?

Regards,

Lee Grant

 

[John Spencer]

Leave off the format and see what happens.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Lee Grant]

Hi John,

Thanks for that pointer. The import worked fine as you suggested...once I'd
removed the text string hidden in the depths of the Excel list!

Should have checked that before I asked for help.

My aplogies and many, many thanks for your time.

Regards,

Lee Grant