Hi Everyone I got another problem every time I try to import data to Sql from Access 2000 it keeps give me an error message that says row 2271. Errors encountered so far in this tabel 1 insert error, column 8 (DOB, DBTYPE_DBTIMESTAMP), status 6: Data overflow. Invalid Character value for cast sepcification.
anyone got any suggestionsWhat is the record in row 2271?|||the same data in 2271 exsist in the rest of the database. columns Category, rehire, firstname..lastname..etc hiredate (date formats date/time)|||I guess, Derrick was asking what is the value of column 8 (DOB) at record 2271. It has to be different vs. let's say record #2270. Is the data type in access also datetime or it's a varchar?|||oh sorry the data in access is date/time data type, not varchar|||Here's where I'm going with this. Give us the CREATE TABLE statement for the SQL Server table you're importing into. Then give use the entire row of data from records 2270 and 2271. We should be able to see what's going on from that easily.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment