Date Format not Available in Access

  • Thread starter Thread starter Kole
  • Start date Start date
K

Kole

I am trying to import a date field that has "DD HH:MM:SS"
into Access 2002. I cannot find a format in Access to
import the field that will keep the number of days
intact. I only see a "HH:NN:SS" format and that changes
the values.
 
Sorry, dates in Access must be complete dates: year and month as well.
That's due to how Access stores dates: they're 8 byte floating point values,
where the integer part represents the date as the number of days relative to
30 Dec, 1899, and the decimal part represents the time as a fraction of a
day. The reason you can import just a time is that Access defaults it to day
0. Try doing a Format( , "yyyy-mm-dd hh:nn:ss") on it, and you'll see it
shows up as 30 Dec, 1899.

Your only option would be to import it as text. Add a date field to the
table, then manipulate the text (using Mid and DateSerial and TimeSerial) to
convert it into a proper date that you can store in the date field.
 
Back
Top