>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.
Nadya,
If it's available, I'd use MapPoint as an automation server and by-pass the table altogether. I don't have the code handy, but you can provide it with a street address, city and state and it can give you the zip code.
George
Ubi caritas et amor, deus ibi est