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.
| Author |
Topic |
|
chachva
Starting Member
2 Posts |
 Posted - 2007-03-14 : 12:21:24
|
| Hi All.........well m importing data from Access 2000 to Ms sql server2000 in this my someof tables are not import due to the error likeerror at destination for Row no.6589.Error encountered so far in this task :1 , Insert error,column 94('chq_Dt',DBTYPE_DBTIMESTAMP),status 6 Data Overflow. Invalid character valu for cast specification.Well in access the Data type of the field chq_dt id Date/time and after importing it becomes like smalldatetime ..so i made it as datetime also but still my data is not copied into sql table...so experts plz anybody help me ...plz give me ur suggetions on chachva_chetan@rediffmail.com..........Hope i will find my solution on ur suggetions...Thanks and waiting 4 reply |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-14 : 13:38:09
|
| If you look at row 6589, you will notice that the value in column 94 has invalid data.The import could not convert the value to a valid datetime value.Peter LarssonHelsingborg, Sweden |
 |
|
|
chachva
Starting Member
2 Posts |
Posted - 2007-03-15 : 03:11:26
|
| Thanks Peso ifound my problem the value in that column was not valid entry as i make some corretion in that it imports all the data...thnks again.. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-15 : 03:48:00
|
| Those darn error messages...Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
DBTYPE_DBTIMESTAMP ERROR