Technical Tips and Solutions
09/03/2007 - Data Overflow. Invalid character value for cast specification
Data Overflow. Invalid character value for cast specification... By Brendan Reynolds - Access MVP
The range of values allowed in an Access Date/Time field and in the SQL Server equivalents is different. An Access Date/Time field accepts dates from 1 Jan 100 to 31 Dec 9999. A SQL Server datetime field accepts dates from 1 Jan 1753 to 31 Dec 9999, while a smalldatetime field accepts dates from 1 Jan 1900 to 6 Jun 2079.
Try running a query on your Access table to see if it has any dates prior to 1 Jan 1900 or later than 6 Jun 2079.