Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 DTS problem MSSQL reading data from ACCESS

Author  Topic 

Johnyalm
Starting Member

49 Posts

Posted - 2001-05-08 : 09:31:06
I have a problem with time formatted like
10:00:00 (HH:MM:SS) in access datatype date/time. When reading it to MSSQL2000 with DTS, I get the error:

"Data overflow. Invalid character value for cast specification."

What am I doing wrong, and what workaround is there?

Thanks in advance,

Johny

www.mirrorgate.com
   

- Advertisement -