Solved

country, state, city and zip code

Posted on 2011-03-12
5
1,354 Views
Last Modified: 2013-12-24
Hi,

Any one know all country names with states and their cities. If possible, then zip code as well. Any database(SQL Server, MySQL) or txt or cvs file?

I have to use with c# code.

Thanks
0
Comment
Question by:sindhuxyz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 39

Expert Comment

by:Aaron Tomosky
ID: 35118561
States I get from USPS. Countries I get from CIA world factbook. Zips ad cities I get from us census but it's a big list.

I haven't even tried to get other countries cities states and zips, it would be huge.
0
 
LVL 33

Expert Comment

by:Todd Gerbert
ID: 35119806
The US Postal Service sells a database you might find useful...it's name escapes me at the moment, but I'm sure you could find it on their website (http://www.usps.com/).
0
 
LVL 4

Expert Comment

by:mawni
ID: 35120268
ISO-3166-Country-Codes.xls
This is all world country list in Excel file, I don't remember the site which I downloaded this file from, I think it contained all the info you needed
0
 
LVL 4

Accepted Solution

by:
mawni earned 500 total points
ID: 35120277
0
 
LVL 5

Author Closing Comment

by:sindhuxyz
ID: 35227523
thanks
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Gift cards are not a new concept - it's been around for a very long time.  Undoubtedly, over the past you have received such a card or purchased one for a friend or relative.  Are you aware that you've been feeding the machine?  If not, read on :)
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Notifications on Experts Exchange help you keep track of your activity and updates in one place. Watch this video to learn how to use them on the site to quickly access the content that matters to you.

738 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