Access to SQL Server

[Stanley]

I am using SQL Server DTS to import an Access 2002 table
into a SQL 2000 Server table. I have a problem with one
field. In access I have it designed as a date field and
formatted as Medium Time. It displays as 10:00 AM, as an
example.
When I import this table I get the error:
insert error. FieldName DBTYPE_DBTIMESTAMP status 6 data
overflow.
Any ideas,
Thanks,
Stan

 

[Van T. Dinh]

I am not sure this applicable to your case or not:

1. In Access, if you don't use the date component of a DateTime Field, the
date value is defaulted to zero which is 30/Dec/1899.

2. In SQL Server, smalldatetime can only store from 01/Jan/1900 (see
B.O.L.)

Perhaps, you need to make sure the newly created Field is of datetime type
rather than smalldatetime.