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

This is the reason I feel so comfortable in recommending AccuZIP to other Allegra’s . Below is an email….subject line really… “Donna is AWESOME!” that I just received from a Philly center. Not just Donna but all customer facing AccuZIP employees are AWESOME!

T.P., Spartanburg, NC