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 |
|
milh467
Starting Member
1 Post |
 Posted - 2009-05-18 : 01:42:50
|
| Hello everyone,This is for my class and I don't know how to figure it out.The assignment is to import .csv (plain flat files comma delimited) into the tables of our database.As I import the data for one of the tables by Tasks -> Import Data, it gives me two errors:"Invalid character value for cast specification""conversion failed because the data value overflowed the specified type"The second error points out that it is on "column 4" which is the column that holds a mix of decimal and whole numbers (42.389 43.23 45 53.389 and so on). I have it set to smallmoney as none of the values go past 3 decimal spaces, but what I noticed on my first run when I did select * from table was that none of the whole numbers got imported and only 80% of the data was imported.So I read through some posts and they suggested switching around data types. I tried int & different varriations of decimals (via ALTER) but that only made things worse! The origional data that got imported lost the decimal values (42.000 43.00 53.000 and etc) . I switched it back to small money and tried reimporting but the decimal values are still missing. What is going on? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-18 : 03:20:39
|
Smallmoney accepts 4 decimal places so the problem is something else.Do you have spaces in the column?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
wrong datatype?