If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Import problem with Time format
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 |
#3
|
|||
|
|||
Import problem with Time format
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 |
#4
|
|||
|
|||
Import problem with Time format
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 |
#5
|
|||
|
|||
Import problem with Time format
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 |
Thread Tools | |
Display Modes | |
|
|