Database Solutions by EQUIP Software
EQUIP Software Home Page | Links | |
![]() | ||
![]() |
Database Area Code Conversion Utility |
For Windows 95, Windows 98, Windows NT and Windows 2000.
Product Description: In 1997 and 1998, there were 21 new area codes added in the United States, and existing area codes were split. Since then, additional area codes have been added, but existing customers were not affected. For all intents and purposes, this application is now obsolete (unless you have some VERY OLD data to convert), but the methods used and actual area code data may be of interest. It is installed as an outside application and attaches any Microsoft Access database under user control. The user can select the Database table and field to be converted. Multiple fields require multiple passes. The targeted Area code must be part of the field. Select the new area code to implement. The current list of 21 available area codes is shown below. The original package included the Microsoft Access runtime engine. Users can easily add their own area code tables. |
Location |
Old Area Code |
New Area Code |
Permissive Dialing Date |
Mandatory Dialing Date |
Arkansas | 501 | 870 | 4/4/97 | 10/6/97 |
California | 916 | 530 | 11/1/97 | 5/16/98 |
California | 818 | 626 | 6/14/97 | 2/21/98 |
California (San Diego) | 619 | 760 | 3/22/97 | 9/27/97 |
California (San Francisco) | 415 | 650 | 8/2/97 | 1/31/98 |
Kansas | 913 | 785 | 7/20/97 | 10/13/98 |
Massachusetts | 617 | 781 | 9/1/97 | 1/1/98 |
Massachusetts | 508 | 978 | 9/1/97 | 1/1/98 |
Michigan | 810 | 248 | 5/10/97 | 9/13/97 |
Michigan | 313 | 734 | 12/13/97 | 7/25/98 |
New Jersey (Central) | 908 | 732 | 6/1/97 | 12/6/87 |
New Jersey (Northern) | 201 | 973 | 6/1/97 | 12/6/87 |
Ohio | 614 | 740 | 11/8/97 | 6/6/98 |
Ohio (Cleveland) | 216 | 440 | 8/16/97 | 4/4/98 |
Oklahoma | 405 | 580 | 11/1/97 | 4/1/98 |
Tennessee | 615 | 931 | 9/15/97 | 1/19/98 |
Texas | 210 | 830 | 7/7/97 | 10/6/97 |
Texas | 210 | 956 | 7/7/97 | 10/6/97 |
Washington State | 206 | 425 | 4/27/97 | 11/16/97 |
Washington State | 206 | 253 | 4/27/97 | 11/16/97 |
Wisconsin | 414 | 920 | 7/26/97 | 10/25/97 |