City, State, Country Field

[Guest]

I need to add to my database three fields for employee birth place:

City - State - Country

I would like to use a List box for State and Country - is there some place I
could copy and paste all the two letter state codes and a List of Countries ?

Thanks

 

[John Vinson]

I need to add to my database three fields for employee birth place:

City - State - Country

I would like to use a List box for State and Country - is there some place I
could copy and paste all the two letter state codes and a List of Countries ?

Thanks

Here are the states, Territories, and Canadian provinces:

StateCode State
AB ALBERTA
AK ALASKA
AL ALABAMA
AR ARKANSAS
AS AMERICAN SAMOA
AZ ARIZONA
BC BRITISH COLUMBIA
CA CALIFORNIA
CO COLORADO
CT CONNECTICUT
DC DISTRICT OF COLUMBIA
DE DELAWARE
FL FLORIDA
FM FEDERATED STATES OF MICRONESIA
GA GEORGIA
GU GUAM
HI HAWAII
IA IOWA
ID IDAHO
IL ILLINOIS
IN INDIANA
KS KANSAS
KY KENTUCKY
LA LOUISIANA
MA MASSACHUSETTS
MB MANITOBA
MD MARYLAND
ME MAINE
MH MARSHALL ISLANDS
MI MICHIGAN
MN MINNESOTA
MO MISSOURI
MP NORTHERN MARIANA ISLANDS
MS MISSISSIPPI
MT MONTANA
NB NEW BRUNSWICK
NC NORTH CAROLINA
ND NORTH DAKOTA
NE NEBRASKA
NH NEW HAMPSHIRE
NJ NEW JERSEY
NL NEWFOUNDLAND AND LABRADOR
NM NEW MEXICO
NS NOVA SCOTIA
NT NORTHWEST TERRITORY
NU NUNAVUT
NV NEVADA
NY NEW YORK
OH OHIO
OK OKLAHOMA
ON ONTARIO
OR OREGON
PA PENNSYLVANIA
PE PRINCE EDWARD ISLAND
PR PUERTO RICO
PW PALAU
QC QUEBEC
RI RHODE ISLAND
SC SOUTH CAROLINA
SD SOUTH DAKOTA
SK SASKATCHEWAN
TN TENNESSEE
TX TEXAS
UT UTAH
VA VIRGINIA
VI VIRGIN ISLANDS
VT VERMONT
WA WASHINGTON
WI WISCONSIN
WV WEST VIRGINIA
WY WYOMING
YT YUKON TERRITORY

I had a table of countries downloaded from a United Nations website
several years ago, but there have been a lot of nations changing since
then, and the old link no longer works.

John W. Vinson[MVP]