Numeric field type for SQL table that allows commas in the number
Posted on 2011-04-20
This should be easy, but then, there is Microsoft. I can't believe the difference between Access and SQL...it is nuts. In Access 2000, I can import the text file I am using from our network into a table and choose a type of 'Double' to accept in a numeric value that has commas and decimals in the number....such as 1,000.000, etc. No problem at all....would have been done days ago.
Now, I try to do a BULK INSERT into SQL, with the same pipe delimited text file on the network, but the SQL table will not import the numbeic value that has the commas and decimals in it, unless I make it into a money category. I don't want it as money, I just want it as a number (could care less if the commas are in there or not, but need the decimals).
How?? It has been proposed to me to import as text into a temp table and then transfer that to the target table with the formatting the way I want, but why should I have to make the server work double duty for one import? How is that efficient?