Sample Zip Code Data for Microsoft Access

Example of Access Table and Form

With the zip code table, you can easily create forms that automatically fill the city and state names when the zip code is entered, and also allow users to select non-primary city names:

In the example above, there are three acceptable city names for zip code 22193. Let your users choose from the list and eliminate typos.

ASCII Files Data Samples

The ASCII Files come in 2 different formats. Both ASCII Files are available to you in addition to the Microsoft Access databases.

File 1: All Zip Codes and Acceptable City and State Names

The first contains all the information with each Zip Code, whether it's the Primary City, City, State, County Number and County Name. A unique identifier exists for each record.

"ID","ZipCode","Primary","City","State","CountyNumber","CountyName"
1,"00210",1,"Portsmouth","NH","015","Rockingham"
2,"00211",1,"Portsmouth","NH","015","Rockingham"
3,"00212",1,"Portsmouth","NH","015","Rockingham"
4,"00213",1,"Portsmouth","NH","015","Rockingham"
11,"00603",1,"Aguadilla","PR","005","Aguadilla"
12,"00603",0,"Ramey","PR","005","Aguadilla"
13,"00604",1,"Aguadilla","PR","005","Aguadilla"
14,"00604",0,"Ramey","PR","005","Aguadilla"

The sample above contains more than one city for zip codes "00603" and "00604".  The "1" denotes the primary city and the "0" denotes a secondary city name for the same zip code.  Some zip codes can have multiple secondary cities.

File 2: Primary City and State for Each Zip Code

The USPS has an official city and state name for each zip code. The second file contains just this Primary location for each zip code without the secondary cities:

"ZipCode","City","State"
"00210","Portsmouth","NH"
"00211","Portsmouth","NH"
"00212","Portsmouth","NH"
"00213","Portsmouth","NH"
"00603","Aguadilla","PR"
"00604","Aguadilla","PR"