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 want you to know that Christine has gone above and beyond to help me fix the problem. She has extraordinary customer service skills. She is a great asset to AccuZIP and their customers

R.K., Germantown, MD