World Postal Zip Code Database

Posted on 2004-04-21
Last Modified: 2008-01-09
Hi, I'm currently using an alright zip code database for the US... but I need to expand to the rest of the world.  I'd like to consolidate this into one database ... and if I cant do that.. I'd like to at least consolidate with one company.  Who's the best out there?  Everybody I find in google looks pretty sketchy.

This will be used for SQL, but that doesn't matter much.

Thanks so much for your help!  I put this at 500 because it's kind of urgent.
Question by:BeamerCola
LVL 11

Expert Comment

ID: 10879010
My company had bought a database that has US Zipcodes -->Area codes.  
No matter who you get the info from, you're gonna have to import it into your database the way you want to have it.

Getting a database of the world zip...  =).. good luck. =)  
I dont know who to go with, but i'd choose one that has a complete database and has been around for quite some time.  If they been in business for a while, then they're probably doing something right.

<>< kT

Author Comment

ID: 10879049
Yeah, thats kinda what I'm asking ... where to find a good one.  I cant spend $25 per country per month ... thats ridiculous.

Expert Comment

ID: 10880061
We have used in the past and they were fine for all US maintained ZIP codes (which include overseas areas that US mail is delivered to, such as military bases).

As far as Global postal codes (ZIP stands for Zone Improvement Program and is specific to the US; Most places use "Postal Codes" instead of ZIP)..  I can't give a good recommendation because I have never used any service.  You might contact your post office and see what they recommend.  

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.


Author Comment

ID: 10880100
yeah thats kinda the same thing I'm using now... I'm having the toughest time finding european postal codes ... There aren't any bigtime companies out there that just offer it all?
LVL 19

Expert Comment

ID: 10885861
Barring USA and Canada, this is going to give you headaches. For majority of nations, such databases don't exist. You can zero down to certain contries and you may do so with limited success. But don't ever expect to find an all correct database of the latest info about any country. Everyone is out-dated in this world.

Expert Comment

ID: 10891936
No objections here

Accepted Solution

PashaMod earned 0 total points
ID: 10918810
Closed, 500 points refunded.
Community Support Moderator

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Read about achieving the basic levels of HRIS security in the workplace.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now