(OT) where to download world list of countries and their cities?

[E.T. Grey]

I need to populate a database with a list of countries of the world,
along with the cities (cities dosent need to be an extensive list). Does
anyone know where I can download such a file? - to save me having to
manually create such a file from (possibly various sources)?

MTIA

[Sjoerd]

Re: (OT) where to download world list of countries and their cities?

E.T. Grey wrote:[color=blue]
> I need to populate a database with a list of countries of the world,
> along with the cities (cities dosent need to be an extensive list). Does
> anyone know where I can download such a file? - to save me having to
> manually create such a file from (possibly various sources)?[/color]

If you do not mind copyright issues, you can take them from one of
these:

http://www.state.gov/m/a/als/1782.htm

http://www.zoomandgo.com/tophotelsABC.asp

[E.T. Grey]

Re: (OT) where to download world list of countries and their cities?



Sjoerd wrote:
[color=blue]
> E.T. Grey wrote:
>[color=green]
>>I need to populate a database with a list of countries of the world,
>>along with the cities (cities dosent need to be an extensive list). Does
>>anyone know where I can download such a file? - to save me having to
>>manually create such a file from (possibly various sources)?[/color]
>
>
> If you do not mind copyright issues, you can take them from one of
> these:
> http://www.state.gov/m/a/als/1782.htm
> http://www.zoomandgo.com/tophotelsABC.asp
>[/color]

many thanks Sjoerd - you're a life saver !