Maxmind the IP Geolocation people also do a massive 3 million plus row text file called worldcitiespop.txt which has all the world's towns, even down to the smallest hamlet, and some of the larger ones populations.
This is very useful of course for some internet applications. The size of the file can present some problems however.
http://www.maxmind.com/download/worldcities/ is where you download it from.
I tried to import it directly into MS SQL 2012 via their SQL Server Import and Export Wizard, but it hit some rows that the default length is insufficient.
I increase the row length for the text columns and it went in fine!
If you are having trouble I have a zipped version in SQL 2012 format which I'll send to you for a modest sum of GBP 20 payable via Paypal! :)
Once your done importing you will need these two links to decode the rest of the file:
Thanks for Maxmind for making available such a useful product!
Here is my import log from SQL 2012 Import Wizard:
© 2004 - 2021 1 Oak Hill Grove Surbiton Surrey KT6 6DS Phone: +44(020) 8123 1321