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

We spoke with several different companies and even had samples sent to us. We chose AccuZIP6 and I have never been happier about spending over $1000 on software in my life.

C.W., Los Angeles, CA