Enter ZIP CODE Get CITY, STATE

[Randomblink]

Ok...
I did some searching, and after 10 different posts that asked similar questions, but didn't give what I was looking for... I decided to ask... So here goes...

I have a db already setup and running.
TO make it easier for end users, I want to setup the ZIP CODE field to grab the City and State based on the ZIP CODE. I use a 9 digit ZIP CODE field to allow for Zip+4 entries, but I know enough VB I believe I can work around that.

What I am looking for IS...
An Excel Spreadsheet / Access Database Table / VBA Code that LISTS all the Zip Codes PER City and State... Where do I get such a beast...? Does anyone know?

Any help would be appreciated... thanks...

 

[pcs]

try http://zipinfo.com

fairly inexpensive and easy to integrate.

you can also download a sample for testing.

hth

 

[WayneRyan]

Brian,

Most of them want $20 - $40, but I found one here for free,
just checking it out now ...

http://www.darkshire.org/~jhkim/programming/zipcodes/

Thank god that my time is worth nothing!

Just looked at it, someone was building a SQL server database.
Happy data mining!

Wayne