D
DaveF
How to I get the db in sql to keep the leading 0's from the import?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Scott M.
What data type do you have the SQL field set to? Try setting it to a char
field.
field.
S
Steve C. Orr [MVP, MCSD]
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.
(char or varchar for example) not a numeric field.
K
Kevin Spencer
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
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
D
DaveF
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
(e-mail address removed)
imported it to a nvarchar. It got rid of the zero's in the beginning
--
David Fetrow
Helixpoint LLC.
http://www.helixpoint.com
(e-mail address removed)
S
Steve C. Orr [MVP, MCSD]
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
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
S
Scott M.
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.
numbers and automatically formats the cells as numeric. Change the format
of the cells to text.