Data types and excel import

  • 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.

Regards,
the_observer.
 
Is the data in Excel is actually a time-value (and not a text/character
value)?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top