Question regarding import in access

T

the_observer

Hi all,
i am a total newbbie in access and i need your help

I try to import a column from an excel file in access.
The column contains times of format hh:mm:secs e.g. 00:49:54

Though i cannot find a data type for this when i create the fields in access.
The most close i can find is Date/Time Data Type and only if i put in format
the short time but it lucks seconds so everything gets imported wrong

What can i do ?

Thank you much for your time reading this.

Regards,
the_observer.
 
C

Clifford Bass

Hi,

Date/Time is the type you want. It probably is indeed importing
correctly. Try removing the format specification. All that does is control
the display of the contents of the field, not its actual values. It should
show the seconds. If it does not, try setting the format to Long Time.

Clifford Bass
 
Top