RE: City/State/County Info by Zip Codes -- MIDRANGE-L

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