?
Solved

country, state, city and zip code

Posted on 2011-03-12
5
Medium Priority
?
1,557 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 2000 total points
ID: 35120277
0
 
LVL 5

Author Closing Comment

by:sindhuxyz
ID: 35227523
thanks
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

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 :)
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
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.
Suggested Courses

777 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