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 |
|
abenitez77
Yak Posting Veteran
53 Posts |
 Posted - 2011-03-31 : 15:00:31
|
| I have a text field that uses | (vertical bar) as the field delimiter. It has numeric data and uses commas with periods (ie 168,324.00). I am having problems importing this text file. It does not like the commas and truncates the number to 168.32. How can I Import this? I tried importing into a table i created that has real type and I tried numeric type. Both don't work. I also have a column that has "010" in it and it truncates leading zeros because it puts it into a real column. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-04-01 : 05:32:07
|
| If the numeric data has comma as part of it, you should use money datatype in the tableMadhivananFailing to plan is Planning to fail |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
import text file with numeric