How do I create the standard country list in Access?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter - 29 Aug 2004 19:29 GMT

I am creating a database for volunteers from all over the World.
I want to set up a table to use in a combo box of the standard list of
countries you get in any web site that asks for your country.
I don't want to have to create the list for myself. First because it will
take for ever a secong because I will miss some out I'm sure.
\how can I get hold of the list?

Reply to this Message

John Vinson - 30 Aug 2004 02:36 GMT

>I am creating a database for volunteers from all over the World.
>I want to set up a table to use in a combo box of the standard list of
>countries you get in any web site that asks for your country.
>I don't want to have to create the list for myself. First because it will
>take for ever a secong because I will miss some out I'm sure.
>\how can I get hold of the list?

Here's one I created about five years ago:

http://community.compuserve.com/n/pfx/forum.aspx?webtag=ws-msdevapps&nav=message
s&tid=19476&tsn=1

Obviously things have changed since then! As I recall the original
data came from a United Nations website; you might try a Google search
for ISO Country Code. It wasn't a huge job to copy the webpage into a
text file, clean it up a bit, and import it.

John W. Vinson[MVP]
(no longer chatting for now)

Reply to this Message