MS SQL Server DTS - import from excel, rounded numbers

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

import from excel, rounded numbers

n_o_s_p_a__m@mail.com

2005-09-27, 1:23 pm

This is probably a common problem, but I failed to find the answer on
the Internet.

I am trying to import the Excel-formatted (rounded to 1 decimal place)
value of a number in a Worksheet into a decimal column. When it
imports, I get the unrounded value. How do I tell DTS to import the
rounded value?

n_o_s_p_a__m@mail.com

2005-09-27, 8:24 pm

I got it, insert as float, then round(colname, 1).

Sponsored Links