Total Zip Code Database

Supports All Versions of Microsoft Access, Office, .NET, and VB6


View all FMS products for Microsoft AccessAll Our Microsoft Access Products

Zip Code Info:

 

"Of all the features I added, automatically filling city and state names when a user entered a zip code turned out to be what my users loved the most. It not only took the least time, it also cost the least to implement. I still can't believe it!"

Anonymous Incredulous Developer

Additional Info:

 

 

Zip Codes for Microsoft Access users and developersZip Codes for Microsoft Access users and developers US Postal Service Zip Codes Sample USPS Zip Codes in a Microsoft Access database

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:

Zip Code Database Sample

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"