World All country City,state list database,dropdown excel csv

I guess a lot of people search for this list and very less get successful finding the list. I also required world's all Country and corresponding City or states for binding the drop down from sql server one of my project. i searched a lot and finally found a very good list, with the approved codes etc. you can use Ajax or anything after importing it to your database in required format in you any of oracle, mysql, access, sql-server, postgresql.
here's Updated link.

http://www.unece.org/cefact/codesfortrade/codes_index.html

above link is for download, below link is for details of various terminologies used.

http://www.unece.org/cefact/locode/welcome.html

on the page you will get list in various acceptable formats from

• txt
• CSV
• excel
• mdb. 

as there is no just download latest file which is on the top of the list and import it to your database.
its very detailed and informative list even got longitude details, district, state, city. so you can drill down to very depth or very less according to your requirements

my best to share the information as far as possible.

Please like this article on Facebook and G+ to make people to find it easily.