Error when upsizing Access table to SQL 2000 date/time field

[ILCSP]

Hi, I'm practicing importing Access tables to SQL 2000 because we're
migrating to SQL in the following months. However, when I try to import
a table that contains a datetime field in access which is used to store
time, I get an data overflow error. (invalid character value for cast
spefication).

I know SQL has different limits when handling dates, and believe me, I
also encountered errors with some of the date fields in my tables. I
already fixed them (had couple of 1200 and 1003 years!) and they're not
a problem. The issue is when the datetime field contains time.

I checked my times and all of them look OK to me: 10:30 AM, 1:00 PM,
7:00 AM and so on (including records that don't have any). I already
removed the index and the input mask in the field, but I still get the
error.

any ideas or advice?

Thanks.

 

[ILCSP]

Hi again, I think I found a solution. In the importing screen in SQL
"Select tables and views," click the transform button and change the
mapping type from smalldatetime to datetime and you'll be ok.