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 |
|
drtduarte
Starting Member
12 Posts |
 Posted - 2009-09-17 : 06:52:04
|
| Dear Friends,I need your help. I've trying for two days to import data from a flat file to an sql table. After several problems with data conversion I guess I'm on the last step but really stuck with this one...I figured out that the best way to get the data was to create a new table with the data, change the columns settings to the correct format of the destination table and import data already at sql.I was able to convert nvarchar to char and varchar without issues, I could also convert one column with 0 value from nvarchar to numeric, but I have one column that I can't convert.I have already the data in the exact format as it should I guess.The data must be in this format 0.000000 (numeric(19,6)and I have it this way, but I still can't convert it, I get the error:- Unable to modify table. Error converting data type nvarchar to numeric.Any one has an idea?Regards,David |
|
|
drtduarte
Starting Member
12 Posts |
Posted - 2009-09-17 : 06:59:17
|
| Ok another step forward, I had two rows empty and it seems that that was the cause, I updated those rows to 0.000000 and I could convert the column to numeric.Now I will try to import the data to the database. |
 |
|
|
|
|
|
Convert nvarchar(50) to numeric(19,6)