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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IMporting in access from excel not correct 1
Data types and excel import 1
Autonumber field in Excel that behaves the same as Access 0
ASK Field Formatting 1
Import Excel 2010 table into Access 2010 - not listed as range 0
30/12/1899 Error when importing Time from Excel to Access 3
how to match number's format in Excel and Access 1
Time format hh:nn drops leading zero 0

Top