a lot of records

Hello, i need two tables like: Country(IDcountry,country_name)...City(IDcity, IDcountry, city_name), so i need to put all the countrys in the world and there respective citys...it´s a lot of records...is there a simple way to do this?Thanks!You can find the ISO list of countries and country codes here:
http://www.iso.ch/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/index.html
If you Google for it I expect you'll find a source of city names to match
your requirements.
I found this one:
http://www.campusprogram.com/reference/en/wikipedia/l/li/list_of_city_listings_by_country.html
--
David Portas
SQL Server MVP
--|||"Paulo Ribeiro" <ubnet@.iol.pt> wrote in message
news:2E344143-D29C-4DBF-AA14-EDA1A67E57DB@.microsoft.com...
> Hello, i need two tables like:
Country(IDcountry,country_name)...City(IDcity, IDcountry, city_name), so i
need to put all the countrys in the world and there respective citys...it´s
a lot of records...is there a simple way to do this?Thanks!
you have to pay for this one:
http://www.meridianworlddata.com/matrix.asp?guid=494A123B-14CB-4532-9592-A88
FFAF7F361&product%5fint%5fid=158|||"Paulo Ribeiro" <ubnet@.iol.pt> wrote in message
news:2E344143-D29C-4DBF-AA14-EDA1A67E57DB@.microsoft.com...
> Hello, i need two tables like:
Country(IDcountry,country_name)...City(IDcity, IDcountry, city_name), so i
need to put all the countrys in the world and there respective citys...it´s
a lot of records...is there a simple way to do this?Thanks!
this one's free:
http://www.worldcityphotos.org/topcities/largest-1to4518.txt