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 |
|
raj07
Starting Member
2 Posts |
 Posted - 2007-08-13 : 03:04:50
|
Hi,I am loading excel data contained in a sheet in to the SQL data base table. The excel sheet contains a column which has numerical values in it and the column is formated to show up to 3 decimal places. I am loading this column in to a decimal column of the table. When I click on the preview of the file the data in this column is shown as it is formated and loaded as that. But when I change the format of the column to general I am able to see the data with all decimal places. Is there any way in which this can be done without changing the format of the column in the excel sheet.Please help me resolve this.You can also mail me at "rajan_vjti@yahoo.co.in"Thanks in advance  ,Rajan |
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-13 : 10:10:30
|
| I am confused. Try to be mopre clear and post with one example what you are trying to do. can u post some sample data.Ashley Rhodes |
 |
|
|
raj07
Starting Member
2 Posts |
Posted - 2007-08-14 : 00:17:56
|
Hi Ashley,Thanks for your reply. I will try to explain what I am doing. Consider an excel sheet which has a column "Values" This column has some numbers in it as "74.2323838049898080480" but, the column is formated by the client who prepares the excel sheet to show the number only up to say 2 decimals i.e "74.23". So now in the excel sheet the value will be shown as "74.2300000". I want to upload the original value ("74.2323838049898080480") in to the data base column with data type decimal by using DTS transformations. What I observe is that when I upload this value in to th etable I get it as "74.23".Can I do something about it (Without having to change the format of the excel column)..........Looking forward to your reply on this.....Thanks!!Rajanquote:
Originally posted by ashley.sql
I am confused. Try to be mopre clear and post with one example what you are trying to do. can u post some sample data.Ashley Rhodes
|
|
|
|
|
|
|
Problem with uploading Decimal values in DTS