IMporting in access from excel not correct

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.
 

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

Data types and excel import 1
30/12/1899 Error when importing Time from Excel to Access 3
Help in Importing from EXcel 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing XML Data in Access 2003 1
Importing an Excel File 1
Importing excel into access 2
Retaining Time Format when Importing 1

Top