RE: City/State/County Info by Zip Codes

ZIP/CITY from Worksright software. It isn't free but, at $495, it isn't
too expensive either. 

With all of the information you require, already on the 400, the amount
of time you'll save trying to get "free" downloads working, it's
probably well worth the $$. JMHI

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Sannan Solberg
Sent: Wednesday, August 18, 2004 5:53 PM
To: Midrange Systems Technical Discussion
Subject: RE: City/State/County Info by Zip Codes


Thanks for all the replies.  My main need for it has to do with getting
the County info "by zip code" so we can update our customer database.
The "sales people" do things by County and we don't currently have that
info on the customers.  Only addresses.  We will not be doing any
validation (but we could).  The reason I'm not worried about keeping it
updated "regularly" is that I can regularly check for customers without
a county on their record, check the zip and if it is new, find out the
info from the USPS site and add it to my table.  We're not talking about
"hundreds of thousands" of customers either, just a couple hundred new
ones per year and a majority of them would already be residing in zip
codes we would (hopefully) have.  

-----Original Message-----
From: Steve Morrison [mailto:smorrison@xxxxxxxxxxxxx]
Sent: Wednesday, August 18, 2004 3:36 PM
To: Midrange Systems Technical Discussion
Subject: RE: City/State/County Info by Zip Codes


I think you will need to be able to update your ZIP Code database, at
least annually. The zip codes do change, as the post office opens and
closes their post offices, and as towns grow and die.

Can you give us some idea of how you expect to utilize this data? Are
you doing mailing list validations, or simply validating zip codes that
customer service reps are entering, or are you doing a shipping/routing
planning project?


Steve Morrison
Beacon Insurance
940-720-4672 

-----Original Message-----
From: Sannan Solberg [mailto:SSolberg@xxxxxxxxxxxx] 
Sent: Wednesday, August 18, 2004 4:07 PM
To: Midrange Systems Technical Discussion
Subject: City/State/County Info by Zip Codes

I've been researching web for such tools and there appears to be plenty
of them but (as expected), my company isn't interested in a "yearly
update" process and some of them are costly.  (read that as "don't spend
any money to do this")

What I'm really shooting to find is a resource that has zipcodes
(preferably ranges of zip codes) with City/State/County information for
each zip (or range of zips).  I only need the US and just want to do
this as a "one time" thing.  Our customer base does not change much so
any maintenance after that is quite minimal (hence, we don't need the
regular updates via an outside product).

Can anyone suggest where I might find such a (free) resource?  I'll take
it just about any flavor (txt, excel, access, db2 table, etc.) and
massage it to get it into my table.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.



_________________________________________________
Scanned on 18 Aug 2004 21:49:17
Scanning by http://erado.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.