leading zeros

#1

I'm not very familiar with excel, but i'm having trouble
importing some fields into sql which are droping their
leading zeros.
ie. 001 becomes 1 in my table.

the column in SQL is char (10).

thanks in advance,
Warren

#2

This may be of use :-

http://www.sqldts.com/default.aspx?254

--
HTH
Ryan Waight, MCDBA, MCSE

"warrenG" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

I'm not very familiar with excel, but i'm having trouble
importing some fields into sql which are droping their
leading zeros.
ie. 001 becomes 1 in my table.

the column in SQL is char (10).

thanks in advance,
Warren

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

leading zeros

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

leading zeros - 11-04-2003 , 02:52 PM

Re: leading zeros - 11-05-2003 , 08:06 AM