robboll
2010-06-24 15:47:59 UTC
I have a simple table with five columns. One of the column is a
date.
When I import the data into a datetime field I get the error: An OLE
DB error has occurred. Error code: 0x80004005. Description:
"Invalid character value for cast specification".
As it turns out the error occurs when it hits a date with this value
"00/00/0000"
Can anyone suggest a method of dealing with this issue?
Thank you!
RBollinger
date.
When I import the data into a datetime field I get the error: An OLE
DB error has occurred. Error code: 0x80004005. Description:
"Invalid character value for cast specification".
As it turns out the error occurs when it hits a date with this value
"00/00/0000"
Can anyone suggest a method of dealing with this issue?
Thank you!
RBollinger