supertrucker Posted January 9, 2007 Share Posted January 9, 2007 Here's what I want, an SQL database that I can use to see what state somebody is in, via their zip code. I would hate to have to program these in myself as there are virtually HUNDREDS of US zip codes out there. I could really use some advice from somebody on this one!Thanks,Supertrucker Link to comment Share on other sites More sharing options...
jesh Posted January 9, 2007 Share Posted January 9, 2007 This page has a comma-delimited list of zip codes, states, and, I believe, cities. Perhaps you could import this data into your database:http://www.census.gov/geo/www/gazetteer/gazette.htmlAlternatively, you can purchase a database of ZipCode information here: http://www.zip-codes.com/Or, you might look into Web Services to see if anyone offers a free Web Service for ZipCode lookups.EDIT: PS, I believe there are literally tens of thousands rather than hundreds. Link to comment Share on other sites More sharing options...
supertrucker Posted January 9, 2007 Author Share Posted January 9, 2007 Thank you, I appreciate the help! I'll let you know how it works out in case anybody else is looking for the same answer as I am!Supertrucker, Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now