IMporting in access from excel not correct

  • Thread starter Thread starter the_observer
  • Start date Start date
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.
 
Back
Top