|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.