Hello,
I have an Access DB with a column [date] holding dates from present day back
to around year 1702, and I am trying to run DTS Import with this MDB, which
fails due to a conversion error.
MSDN says the datetime data type only allows 1753-01-01 to 1900-01-01, thus
I am under the impression having the [date] field as varchar is the only way
to store the dates.
My questions are:
a) Can dates prior to 1753-01-01 be stored in a date column?
b) If dates are in a column of type varchar (or similar) is it possible to
sort them chronologically with T-SQL ?
c) 1753-01-01 seems particularly arbitrary, any reason for this?
Many thanks for any help, it's driving me mad!
John