Import problem with Time format

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
'================================================= ===


Lee Grant wrote:
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

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" wrote in message
...
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 wrote:
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

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 wrote:
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" wrote in message
...
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 wrote:
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

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


"John Spencer" wrote in message
...
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 wrote:
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" wrote in message
...
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 wrote:
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