MS SQL Server - Zip Code Import

Author

Zip Code Import

Colette

2006-10-24, 6:37 pm

I need to derive address information from the zip code. I have a zip code
file that I need to put into a SQL table. What's the best way to do that?

ryanlsanders@gmail.com

2006-10-24, 6:37 pm

Are you asking what is the best was to get the zip code file into an
SQL table?

If you are on SQL 2000 then use the a DTS to bring in the file into
your table, its on your start menu called import and export data.

Colette wrote:
> I need to derive address information from the zip code. I have a zip code
> file that I need to put into a SQL table. What's the best way to do that?

Paul Ibison

2006-10-24, 6:37 pm

What format is the data in? If it is a csv or tabl-delimited, then DTS/SSIS
is the tool to use. In the UK the postcode files I have to use are 'ragged
files' for some obscure reason, and if yours are like that, you'll be best
off doing row-by-row parsing of text files using a programming language.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Arnie Rowland

2006-10-24, 6:37 pm

See reply under microsoft.public.sqlserver.dts

And, ...

Often, the quality of the responses received is related to our ability to
'bounce' ideas off of each other. In the future, to make it easier for us to
give you ideas, and to prevent folks from wasting time on already answered
questions, please:

Don't post to multiple newsgroups. Choose the one that best fits your
question and post there. Only post to another newsgroup if you get no answer
in a day or two (or if you accidentally posted to the wrong newsgroup -and
you indicate that you've already posted elsewhere).

If you really think that a question belongs into more than one newsgroup,
then use your newsreader's capability of multi-posting, i.e., posting one
occurrence of a message into several newsgroups at once. If you multi-post
appropriately, answers 'should' appear in all the newsgroups. Folks
responding in different newsgroups will see responses from each other, even
if the responses were posted in a different newsgroup.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

"Colette" <Colette@discussions.microsoft.com> wrote in message
news:65739FB7-0684-4232-A15B- 982AF245B1B7@microso
ft.com...
>I need to derive address information from the zip code. I have a zip code
> file that I need to put into a SQL table. What's the best way to do that?

Sponsored Links