>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.
Rip Ryness
International Falls, MN