Create an Excel file with count on 5-digit ZIP Codes

This command will create an excel file listing each ZIP Code in your database and the quantity in each ZIP.

com_alias=alias() ON ERROR com_message=message() SET SAFETY OFF alter table alias() add column zip5 c(5) replace all zip5 with left(zip,5) SELECT zip5, city, st, count (zip5) as zipcnt ; from (com_alias) group by 1,2,3 into table FORCEEXT(DBF(),"")+"-zip5_count" copy to FORCEEXT(DBF(),"XLS") type XLS use SELECT (com_alias) delete file FORCEEXT(DBF(),"")+"-zip5_count.dbf"

com_alias=alias()
ON ERROR com_message=message()
SET SAFETY OFF
alter table alias() add column zip5 c(5)
replace all zip5 with left(zip,5)
SELECT zip5, city, st, count (zip5) as zipcnt ;
from (com_alias) group by 1,2,3 into table FORCEEXT(DBF(),"")+"-zip5_count"
copy to FORCEEXT(DBF(),"XLS") type XLS
use
SELECT (com_alias)
delete file FORCEEXT(DBF(),"")+"-zip5_count.dbf"

« Back to Commands

New to the
Mailing
Industry?
More Info

Professional Services
More Info

I have been working in pretty much all areas of senior-level IT and Data Processing for many years and have had countless hours of experience engaging with customer support. I’ve never had better support than what I receive from Accuzip! Seriously, any time I call, email, or go to the online chat, someone responds in less than a minute, is always very patient and pleasant, and resolves my issue quickly. Aside from just fixing the problem, your support team always takes the time to explain what the problem was and how to prevent it. It is very refreshing and encouraging to see that real support still exists. Thanks to the Accuzip Team! I look forward to many more years of engagement with your Team.

M.M., Scottsdale, AZ