«

How to I get the db in sql to keep the leading 0's from the import?

--


David

What data type do you have the SQL field set to? Try setting it to a char
field.


"DaveF" <> wrote in message
news:...
> How to I get the db in sql to keep the leading 0's from the import?
>
> --
>
>
> David
>
>

Make sure you're storing the zip code in a text field of one kind or another
(char or varchar for example) not a numeric field.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net


"DaveF" <> wrote in message
news:...
> How to I get the db in sql to keep the leading 0's from the import?
>
> --
>
>
> David
>
>

This point can't be emphasized enough. A Zip Code is NOT a number. It is a
string containing a sequence of numeric characters. Some Zip Codes include
hyphens, as in:

12345-0123

Some Zip Codes Begin with '0'. If you treat them like numbers, you will
corrupt the data.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
I get paid good money to
solve puzzles for a living

"Steve C. Orr [MVP, MCSD]" <> wrote in message
news:...
> Make sure you're storing the zip code in a text field of one kind or
another
> (char or varchar for example) not a numeric field.
>
> --
> I hope this helps,
> Steve C. Orr, MCSD, MVP
> http://Steve.Orr.net
>
>
> "DaveF" <> wrote in message
> news:...
> > How to I get the db in sql to keep the leading 0's from the import?
> >
> > --
> >
> >
> > David
> >
> >
>
>

They are in an access db as a string. I exported it to a excell file and
imported it to a nvarchar. It got rid of the zero's in the beginning

--


David Fetrow
Helixpoint LLC.
http://www.helixpoint.com

"Kevin Spencer" <> wrote in message
news:...
> This point can't be emphasized enough. A Zip Code is NOT a number. It is a
> string containing a sequence of numeric characters. Some Zip Codes include
> hyphens, as in:
>
> 12345-0123
>
> Some Zip Codes Begin with '0'. If you treat them like numbers, you will
> corrupt the data.
>
> --
> HTH,
> Kevin Spencer
> .Net Developer
> Microsoft MVP
> I get paid good money to
> solve puzzles for a living
>
> "Steve C. Orr [MVP, MCSD]" <> wrote in message
> news:...
> > Make sure you're storing the zip code in a text field of one kind or
> another
> > (char or varchar for example) not a numeric field.
> >
> > --
> > I hope this helps,
> > Steve C. Orr, MCSD, MVP
> > http://Steve.Orr.net
> >
> >
> > "DaveF" <> wrote in message
> > news:...
> > > How to I get the db in sql to keep the leading 0's from the import?
> > >
> > > --
> > >
> > >
> > > David
> > >
> > >
> >
> >
>
>

I suspect Excel clipped the zeros.
It's notorious for such things.
Try to make sure Excel sees that data column as a text column.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net



"DaveF" <> wrote in message
news:...
> They are in an access db as a string. I exported it to a excell file and
> imported it to a nvarchar. It got rid of the zero's in the beginning
>
> --
>
>
> David Fetrow
> Helixpoint LLC.
> http://www.helixpoint.com
>
> "Kevin Spencer" <> wrote in message
> news:...
>> This point can't be emphasized enough. A Zip Code is NOT a number. It is
>> a
>> string containing a sequence of numeric characters. Some Zip Codes
>> include
>> hyphens, as in:
>>
>> 12345-0123
>>
>> Some Zip Codes Begin with '0'. If you treat them like numbers, you will
>> corrupt the data.
>>
>> --
>> HTH,
>> Kevin Spencer
>> .Net Developer
>> Microsoft MVP
>> I get paid good money to
>> solve puzzles for a living
>>
>> "Steve C. Orr [MVP, MCSD]" <> wrote in message
>> news:...
>> > Make sure you're storing the zip code in a text field of one kind or
>> another
>> > (char or varchar for example) not a numeric field.
>> >
>> > --
>> > I hope this helps,
>> > Steve C. Orr, MCSD, MVP
>> > http://Steve.Orr.net
>> >
>> >
>> > "DaveF" <> wrote in message
>> > news:...
>> > > How to I get the db in sql to keep the leading 0's from the import?
>> > >
>> > > --
>> > >
>> > >
>> > > David
>> > >
>> > >
>> >
>> >
>>
>>
>
>

The zeros came off when you brought the data into Excel, since Excel see's
numbers and automatically formats the cells as numeric. Change the format
of the cells to text.


"DaveF" <> wrote in message
news:...
> They are in an access db as a string. I exported it to a excell file and
> imported it to a nvarchar. It got rid of the zero's in the beginning
>
> --
>
>
> David Fetrow
> Helixpoint LLC.
> http://www.helixpoint.com
>
> "Kevin Spencer" <> wrote in message
> news:...
>> This point can't be emphasized enough. A Zip Code is NOT a number. It is
>> a
>> string containing a sequence of numeric characters. Some Zip Codes
>> include
>> hyphens, as in:
>>
>> 12345-0123
>>
>> Some Zip Codes Begin with '0'. If you treat them like numbers, you will
>> corrupt the data.
>>
>> --
>> HTH,
>> Kevin Spencer
>> .Net Developer
>> Microsoft MVP
>> I get paid good money to
>> solve puzzles for a living
>>
>> "Steve C. Orr [MVP, MCSD]" <> wrote in message
>> news:...
>> > Make sure you're storing the zip code in a text field of one kind or
>> another
>> > (char or varchar for example) not a numeric field.
>> >
>> > --
>> > I hope this helps,
>> > Steve C. Orr, MCSD, MVP
>> > http://Steve.Orr.net
>> >
>> >
>> > "DaveF" <> wrote in message
>> > news:...
>> > > How to I get the db in sql to keep the leading 0's from the import?
>> > >
>> > > --
>> > >
>> > >
>> > > David
>> > >
>> > >
>> >
>> >
>>
>>
>
>