Invalid character value for cast specification??

[Sheffield]

I'm attempting to import Access2000 *.mdb into SQL Server 7.0. All of my tables (except one) converted successfully.

Here is the error I received:

Error at Destination for Row number 1. Errors encountered so far in this task: 1. Invalid character value for cast specification.


Can anyone tell me what this actually means? Is there anything specific that I should look for?

All responses are greatly appreciated

 

[aalmeida]

That meand that you may have a data type on access that is not implicity convetible to the sql datatype.
Investigate the cas / convert function on sql server and the data type on Access, the portable datatype that is trying to create.
I could be that just a an example 11/5/01 is a date but SQL server would not convert from char to datetime, it would say something like "out of range converting datetime from char" because the expected char would be 11/05/01.
That's all It comes to mind right now, let me know further
AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"