The USPS department called AMS (Address Management Service) sells this data
in subscription format - we get it monthly. Don't know cost, and data is
provided in ascii file that you the load into a table of your design. We
use SQL Loader for the piece we need and it loads (with truncate existing
Interesting. Apparently, my ZIP in a city of 24K people didn't make the
list.
I guess you get what you pay for. :)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Wednesd
As long as you don't need current data. This page says the file was
last updated Jan 8, 1997. In my personal contact manager, I'm still
using one I downloaded from quite some time ago. Unless you need real
current data, the price is right. (Send the guy $10 though)
Stephen
>>> [EMAIL PROTEC
Have you check the USPS web site? RBG
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 21, 2002 9:13 AM
> Hi All,
>
> Where can I get a list of all zip codes,city,states to load into a table.
I
> have searched but cannot find an
Rick,
You can purchase what you want from the USPS for something like $300. I have
never seen it free.
http://www.usps.com/ncsc/
Cheers,
Thom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farrell, Thomas M.Mr. NGB-ARNG
INET: [EMAIL PROTECTED]
Fat City Network Ser
AIL PROTECTED] To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
>cc:
Sent by: Subject: Re: List of all zip
codes,c
Rick - I think Barbara is right, to get the info in bulk you'll probably
have to pay. A few years ago a friend of mine got a diskette from the U.S.
Post Office that was intended to get bulk mailers to use 9-digit zip codes.
Might be worth a check.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECT
I've heard good things about Quick Address over here in the UK, and see that
they may have a US version as well:
http://www.postcode.com/us/
HTH
Mark
===
Mark Leith | T: +44 (0)1905 330 281
Sales & Marketing | F: +44 (0)870 127
I think you have to buy this kind of thing ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have fac
Title: RE: List of all zip codes,city,state to load into table.
Hi, Hope this helps. Its a text file, then you can load it using SQLloader etc.
http://www.cwpm.com/ZIP_DB.html
-Original Message-
From: [EMAIL PROTECTED]@SUNGARD On Behalf Of [EMAIL PROTECTED]
Sent
www.zipinfo.com
-Original Message-
[EMAIL PROTECTED]
Sent: Wednesday, August 21, 2002 6:14 AM
To: Multiple recipients of list ORACLE-L
Hi All,
Where can I get a list of all zip codes,city,states to load into a table. I
have searched but cannot find anything to download.
Anyone have a U
Hi Rick,
There are alot of services out there that will sell you a database, with
periodic updates. Here's one -
www.zipinfo.com
Beth
-Original Message-
Sent: Wednesday, August 21, 2002 9:14 AM
To: Multiple recipients of list ORACLE-L
Hi All,
Where can I get a list of all zip cod
Rick:
We pay for a service that gives us this info (for the U.S. and Canada).
The service is from GreatData (www.greatdata.com). They send us updated
zips about once a quarter.
HTH.
Barb
> --
> From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
>
If you need zip codes, city, streets for Czech Republic I can send it to you
:-)))
JP
--
Pruner Jan
[EMAIL PROTECTED]
http://jan.pruner.cz/
-
On Wednesday 21 August 2002 15:13, you wrote:
> Hi All,
>
> Where can I get a list of all zip codes,ci
14 matches
Mail list logo