Import problem with Time format

  • Thread starter Thread starter Lee Grant
  • Start date Start date
L

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
 
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
'====================================================
 
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
 
Leave off the format and see what happens.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
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
 
Back
Top