Support 805.461.7300
Sales
NEW SITE. Our Technology. Your Success.

Create a new database for every Unique State in the database

This command will identify each unique state in your address list and create one new file for each state represented.
For example, if you have 50 records in Alaska and 100 records in Hawaii, this command will create an Alaska database with your database's 50 Alaska records and a separate Hawaii database with the 100 records from your database that were in the state of Hawaii.

1. Download and extract the unique_st.zip file to the C:\Program Files (x86)\AccuZIP6 5.0 folder.
2. Create a command from the Edit>Command window. Type the following into the Command Statement Syntax area:

 
DO UNIQUE_ST

3. The command will create a directory named “C:\ST files” and populate with separate dbf’s for each state in the database.

« Back to Commands

While we have consistently been impressed with the level of assistance we receive through your online chat portal, Geoff has been more than helpful and great to work with on every issue we’ve come across. He is quick to diagnose and resolve the issues. He also has offered to instruction and information to prevent future issues. He has even guided us through some functions of Accuzip we had not previously been utilizing. I wanted to take a minute and give a huge shout out to Geoff.
T.A., Grand Rapids, MI