L
Lisa W.
I have an excel file that I'm importing to Access. This field consists of
"time"...hours, minutes, seconds. The format in excel is set to "Custom" -
[h]:mm:ss.
The data elements look like 150:27:50, 2:30:25, etc...
The time stays the same for some records but others change. For
example...150:27:50 becomes 6:27:50 AM when imported.
If someone can help me figure a way to retain the format for all records I
would greatly appreciate it.
Thank You,
Lisa W.
"time"...hours, minutes, seconds. The format in excel is set to "Custom" -
[h]:mm:ss.
The data elements look like 150:27:50, 2:30:25, etc...
The time stays the same for some records but others change. For
example...150:27:50 becomes 6:27:50 AM when imported.
If someone can help me figure a way to retain the format for all records I
would greatly appreciate it.
Thank You,
Lisa W.