dbWriter Home
IP to Country Look up
Site Map

IP to Country DB

Free Databases:

ASP Code

ASP Links

VB Script functions:
Array
Case/Select
In String (inStr)
Replace

HTML code:
SELECT Color
SELECT Countries
SELECT Language
SELECT State/Province

SQL:

SQL Functions:
Delete leading Char
Get Browser
Long number from IP

Stored Procedures:

SQL Tricks:
Delete ALL duplicates
Delete dup records

MISC
IP Address Owner
MS SQL Server

Mortgage Calcs:
how much is my payment
Loan Amortization
Loan Calculator
Mortgage Calculator
Motrgage Pay Off

dbWriter License

Link to US

Links

Contact US
 

dbWriter Free United States zip codes access database

MS Access US ZIP codes with Latitude and Longitude compiled into a MS Access database with over 40,000 entries.
Database includes a Zip code table, State Code table and Class code table.

Download the database -- Click here

Although every effort is made to ensure the accuracy of our free databases we cannot guarantee them being 100% accurate.

sample Zip code table data

ZIP Codes
ZIP Code Latitude Longitude Class City State Code
38579 +35.83677 -085.54634
 		 QUEBECK 47
38580 +36.28122 -085.30479
 		 RICKMAN 47
38581 +35.76675 -085.67884
 		 ROCK ISLAND 47
38582 +36.10737 -085.72946
 		 SILVER POINT 47
38583 +35.94385 -085.43924
 		 SPARTA 47
38585 +35.67781 -085.43435
 		 SPENCER 47
38587 +35.86647 -085.60923
 		 WALLING 47
38588 +36.43321 -085.70795
 		 WHITLEYVILLE 47
38589 +36.28218 -085.09131
 		 WILDER 47
38601 +34.47194 -089.44750
 		 ABBEVILLE 28
38602 +34.68627 -090.10675 P ARKABUTLA 28
38603 +34.74145 -089.16328
 		 ASHLAND 28
38606 +34.34310 -089.95649
 		 BATESVILLE 28
38609 +34.23511 -090.29272 P BELEN 28
38610 +34.66799 -088.99877
 		 BLUE MOUNTAIN 28
38611 +34.84810 -089.61769
 		 BYHALIA 28
38614 +34.25600 -090.63480
 		 CLARKSDALE 28
38617 +34.30802 -090.51994
 		 COAHOMA 28
38618 +34.69018 -089.96251
 		 COLDWATER 28
38619 +34.47402 -089.95442
 		 COMO 28
38620 +34.25082 -089.96299
 		 COURTLAND 28
38621 +34.44705 -090.10120
 		 CRENSHAW 28
38622 +34.17305 -090.13642 P CROWDER 28
38623 +34.29161 -090.29271 P DARLING 28
38625 +34.64173 -088.82712
 		 DUMAS 28
38626 +34.53570 -090.36930
 		 DUNDEE 28
38627 +34.43294 -089.05727
 		 ETTA 28
38628 +34.29161 -090.29271
 		 FALCON 28
38629 +34.85087 -088.93374
 		 FALKNER 28
38630 +34.24235 -090.64886 P FARRELL 28
38631 +34.37406 -090.60605 P FRIARS POINT 28
38632 +34.80684 -089.99459
 		 HERNANDO 28
38633 +34.62344 -089.18030
 		 HICKORY FLAT 28
38634 +34.74504 -089.48496 P HOLLY SPRINGS 28
38635 +34.77473 -089.51387
 		 HOLLY SPRINGS 28
38637 +34.95060 -090.03355
 		 HORN LAKE 28
38638 +34.69585 -089.82879 P INDEPENDENCE 28
38639 +34.30373 -090.42935 P JONESTOWN 28
38641 +34.91183 -090.14603
 		 LAKE CORMORANT 28
38642 +34.93032 -089.39992
 		 LAMAR 28
38643 +34.18923 -090.21591
 		 LAMBERT 28
38644 +34.46179 -090.49808 P LULA 28
38645 +34.23638 -090.47941
 		 LYON 28
38754 +33.26304 -090.59677
 		 ISOLA 28
38756 +33.39850 -090.88387
 		 LELAND 28
38758 +34.07679 -090.50701 P MATTSON 28
38759 +33.81874 -090.84063
 		 MERIGOLD 28
38760 +33.45461 -090.99426 P METCALFE 28
38761 +33.44338 -090.50681
 		 MOORHEAD 28
38762 +33.76712 -090.84697
 		 MOUND BAYOU 28
38763 +32.87979 -090.81096 P NITTA YUMA 28
38764 +33.72571 -090.92728 P PACE 28
38765 +32.87979 -090.81096 P PANTHER BURN 28
38767 +34.14120 -090.78650
 		 RENA LARA 28
38768 +33.95895 -090.47760 P ROME 28
38769 +33.84189 -090.88259
 		 ROSEDALE 28
38771 +33.66479 -090.55553
 		 RULEVILLE 28
38772 +33.56287 -091.03909 P SCOTT 28
38773 +33.60853 -090.79434
 		 SHAW 28
38774 +33.95775 -090.74504
 		 SHELBY 28
38776 +33.40961 -090.91040 P STONEVILLE 28
38778 +33.55674 -090.54511
 		 SUNFLOWER 28
38780 +33.27269 -090.99539 P WAYSIDE 28
38781 +33.88777 -090.73714 P WINSTONVILLE 28
38782 +33.26911 -090.95729
 		 WINTERVILLE 28
38801 +34.29188 -088.68382
 		 TUPELO 28
38802 +34.23452 -088.76712 P TUPELO 28
38803 +34.18763 -088.77852 P TUPELO 28
38804 +34.33710 -088.68467
 		 TUPELO 28
38820 +34.17154 -089.03279 P ALGOMA 28
38821 +33.94263 -088.41128
 		 AMORY 28
38824 +34.31481 -088.63922
 		 BALDWYN 28
38825 +33.86976 -088.46217 P BECKER 28
38826 +34.26984 -088.74593
 		 BELDEN 28
38827 +34.55066 -088.22674
 		 BELMONT 28
38828 +34.46425 -088.95860
 		 BLUE SPRINGS 28
38829 +34.63292 -088.53310
 		 BOONEVILLE 28
38833 +34.85598 -088.28692
 		 BURNSVILLE 28
38834 +34.87589 -088.59157
 		 CORINTH 28
38835 +34.92045 -088.52177 P CORINTH 28
38838 +34.58462 -088.24839
 		 DENNIS 28
38839 +33.85616 -089.30321 P DERMA 28
38841 +34.33660 -089.01087
 		 ECRU 28
38843 +34.27648 -088.35501
 		 FULTON 28
38844 +33.84026 -088.26350
 		 GATTMAN 28
38846 +34.86852 -088.41982
 		 GLEN 28
38847 +34.34632 -088.24602
 		 GOLDEN 28
38848 +33.94007 -088.32071
 		 GREENWOOD SPRINGS 28
38849 +34.42108 -088.66597
 		 GUNTOWN 28
38850 +34.01357 -088.99610
 		 HOULKA 28
38851 +33.91190 -088.93114
 		 HOUSTON 28
38852 +34.81583 -088.23180
 		 IUKA 28
38854 +33.90682 -088.95535
 		 MC CONDY 28
38855 +34.32437 -088.39318
 		 MANTACHIE 28
38856 +34.59278 -088.51035
 		 MARIETTA 28
38857 +34.27500 -088.59285
 		 MOOREVILLE 28
38858 +34.16184 -088.47214
 		 NETTLETON 28
38859 +34.53146 -088.38751
 		 NEW SITE 28
38860 +33.94295 -088.86802
 		 OKOLONA 28
38862 +34.23954 -088.61745
 		 PLANTERSVILLE 28
38863 +34.22724 -089.04053
 		 PONTOTOC 28
38864 +34.16174 -089.17946
 		 RANDOLPH 28
38865 +34.81888 -088.56325
 		 RIENZI 28
38866 +34.30437 -088.66720
 		 SALTILLO 28
38868 +34.14414 -088.68396
 		 SHANNON 28
38869 +34.34954 -088.83626 P SHERMAN 28
38870 +34.04526 -088.36560
 		 SMITHVILLE 28
38871 +34.31736 -089.15905
 		 THAXTON 28
38873 +34.67120 -088.23806
 		 TISHOMINGO 28
38874 +34.22652 -089.25192 P TOCCOPOLA 28
38875 +33.90682 -088.95535 P TREBLOC 28
38876 +34.23514 -088.33345
 		 TREMONT 28
38877 +33.98708 -088.89880 P VAN VLEET 28
38878 +33.89696 -089.22189
 		 VARDAMAN 28
38879 +34.17069 -088.75907 P VERONA 28
38880 +34.61263 -088.58223 P WHEELER 28
38901 +33.78601 -089.84546
 		 GRENADA 28
38902 +33.82411 -089.79468 P GRENADA 28
38912 +33.65497 -090.05395 P AVALON 28
38913 +34.12266 -089.39577
 		 BANNER 28
38914 +33.89821 -089.43186
 		 BIG CREEK 28
38915 +34.03463 -089.34266
 		 BRUCE 28
38916 +33.85717 -089.35248
 		 CALHOUN CITY 28
38917 +33.51842 -089.99597
 		 CARROLLTON 28
38920 +33.92920 -090.18846
 		 CASCILLA 28
38921 +34.00742 -090.11536
 		 CHARLESTON 28
38922 +33.96128 -089.64824
 		 COFFEEVILLE 28
38923 +33.44568 -089.91007
 		 COILA 28
38924 +33.25558 -090.18334
 		 CRUGER 28
38925 +33.56322 -089.64187
 		 DUCK HILL 28
38926 +33.68947 -089.75830 P ELLIOTT 28
38927 +34.12505 -090.01318
 		 ENID 28
38928 +33.92920 -090.18846
 		 GLENDORA 28
38929 +33.78764 -089.64719
 		 GORE SPRINGS 28
38930 +33.55040 -090.22485
 		 GREENWOOD 28
38935 +33.52335 -090.27757 P GREENWOOD 28
38940 +33.74296 -090.00046
 		 HOLCOMB 28
38941 +33.46785 -090.29463
 		 ITTA BENA 28
38943 +33.48956 -089.83446
 		 MC CARLEY 28
38944 +33.75213 -090.37412
 		 MINTER CITY 28
38945 +33.65068 -090.19690 P MONEY 28
38946 +33.40457 -090.37199 P MORGAN CITY 28
38947 +33.51275 -089.92012 P NORTH CARROLLTON 28
38948 +34.10265 -089.85531
 		 OAKLAND 28
38949 +34.19924 -089.38199
 		 PARIS 28
38950 +33.73343 -090.23705
 		 PHILIPP 28
38951 +33.94294 -089.28300
 		 PITTSBORO 28
38952 +33.62735 -090.30102
 		 SCHLATER 28
38953 +34.02973 -089.71952
 		 SCOBEY 28
38954 +33.44568 -089.91007
 		 SIDON 28
38955 +33.74387 -089.37528
 		 SLATE SPRING 28
38957 +33.98332 -090.38952 P SUMNER 28
38958