>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.


We are on a subscription with the Post Office. They send us updates every quarter. Their file format is kind'uv tricky and if you want a unique listing of zipcodes it's even trickier but I use it. There are ~43000 unique zip codes in the US so your table is not unique but that probably doesn't matter.