[AccessD] OT - ISO 3166 Country Codes

Many thanks Gustav!

I've updated my spreadsheets at <http://tenbus.co.uk/iso3166/> to include
English, French, German, and Spanish names.

The region names version (in Provincias.zip) is a particularly good find -
many thanks!

I'm going to start on adding local, Danish, Norwegian, and Swedish language
versions.

Regards
Chris F

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: 01 January 2007 18:43
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] OT - ISO 3166 Country Codes


Hi all

Notice that the ISO 3166-2 list (with region names) which is hard to get is
contained in the file Provincias.zip and only the field names are in
Spanish. The other file, Paises.zip, contains the ISO 3166-1 list (country
names only) in Spanish and includes both the two- and three-letter country
codes.

Also, note that most lists available except for those from iso.org are not
up to date, and that full lists sadly are not free at iso.org. 
However, update letters are available for free here:

http://www.iso.org/iso/en/prods-services/iso3166ma/03updates-on-iso-3166/ind
ex.html 

so you would be able to run your own updating.

Finally, note that some entries are not "real" countries. At least for the
Scandinavian countries, Faeroe Islands and Greenland belong to Denmark and
Åland Islands belong to Finland.

/gustav