>Hi everyone,
>
>Do you know, where can I download a file with ZIPCODES in each town in US? I have a table called ZIP_5 with this structure:
>

>CityName  C(28)
>State     C(2)
>ZipCode   C(5)
>AreaCode  C(3)
>CountyFips C(3)
>CountyName C(25)
>PrefCode   C(1)

>It has 73703 records.
>
>I don't remember, how we populated it the first time, but I found, that the info here is old, so we need to re-download it.
>
>Thanks in advance.

If one of the URLs don't have what you want I've got an ascii zip file on one of my drives at work.
JLK

http://www.oseda.missouri.edu/jgb/ZIP.resources.html
www.census.gov/ftp/pub/tiger/tms/gazetteer/counties.txt

or for $$$
http://www.semaphorecorp.com/cgi/zp4.html
http://www.pc-shareware.com/zipcode.htm
http://www.emory.com/progress/dnload.htm
http://www.zipinfo.com/products/cdz/cdz.htm
http://www.bizbasics.net/shipzipz.html