Results 1 to 9 of 9
  1. #1
    Join Date
    Jan 2004
    Posts
    12

    Unanswered: Need to update old area codes

    I have files with area codes that are several years old. Everything I've seen about updating area codes deals with area codes that are current and are about to split in the near future. How would I go about bringing old area codes up to date?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    It's based on the area code and the exchange...go to usps site...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    Er, Brett, are you sure you want to point sync to the Postal Service? Why would they give a rat's ass about area codes?

    Could you provide a URL?

    I would love to have a consistant source of Area codes, not to mention international codes. right now I have to search around scrubbing various web sites for up to date lists.
    -bpd

  4. #4
    Join Date
    Jan 2004
    Posts
    12
    bpdWork, Which web sites are you using to get your lists? At the moment I'm not even sure what kind of data I need to do the job.

  5. #5
    Join Date
    Aug 2001
    Location
    CT
    Posts
    8

    Area Codes Database

    Originally posted by sync
    bpdWork, Which web sites are you using to get your lists? At the moment I'm not even sure what kind of data I need to do the job.
    http://www.nanpa.com/nanp1/AllCodes.zip

  6. #6
    Join Date
    Jan 2004
    Posts
    12

    Re: Area Codes Database

    Thank you jbroyles. It seems that in order to use the NANPA data, the area codes that need updating must have dates associated with them. Is that correct? My data does not have dates.

    Peter

  7. #7
    Join Date
    Aug 2001
    Location
    CT
    Posts
    8

    Re: Area Codes Database

    Originally posted by sync
    Thank you jbroyles. It seems that in order to use the NANPA data, the area codes that need updating must have dates associated with them. Is that correct? My data does not have dates.

    Peter
    It seems you would be correct.

  8. #8
    Join Date
    Jan 2004
    Posts
    12
    bump

  9. #9
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    [doooh]
    postal service
    [/dooh]

    I used to have a linke...it might have been ATT...

    try this

    http://www.vzmultimedia.com/customer...t_changes.html

    or this

    http://www.consumer.att.com/global/e...usa_codes.html

    There used to be a conversion list using exchanges.....
    Last edited by Brett Kaiser; 02-04-04 at 17:35.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •