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 wanted to drop you a line to tell you that working with Accuzip has been a breath of fresh air. I’ve been able to speak with a Live person each and every time I call. Your unlimited Tech Support, Personal Training and Price Lock Guarantee has given me the confidence that I made the right choice. Accuzip was able to solve my list issues and add value to my existing database at a more than reasonable price.

J.S., Newark, OH