Zip code List

[Dick7Access]

Anybody know where I can get a list of all the zip codes in the USA, so that I can cut and paste the whole list and not have to type each one in my hand?

 

[jdraw]

Dick,

There is a free download available for personal/non commercial use at
http://www.unitedstateszipcodes.org/zip-code-database/

In most countries zip/postal codes are maintained by PostOffice and are a for sale item.
Usually anything with this info for free is considered out of date by many. However, it may serve you well. If you need the latest info, you could purchase/buy into a service.

Good luck.

 

[Dick7Access]

Dick,

There is a free download available for personal/non commercial use at
http://www.unitedstateszipcodes.org/zip-code-database/

In most countries zip/postal codes are maintained by PostOffice and are a for sale item.
Usually anything with this info for free is considered out of date by many. However, it may serve you well. If you need the latest info, you could purchase/buy into a service.

Good luck.

Does excel eliminate leading zero's

 

[Dick7Access]

I have save a copy of the Excel Zip Codes but when I go to external data from my db it can't see the copy. From Excel it can see it and will open it. Anybody know why?

 

[pr2-eugin]

Its a CSV file Dick.. Save it to an Excel format before using Data import..

 

[jdraw]

Dick, I copied the csv to an Access mdb.
There were 2 import errors.
I am attaching the database, with 2 tables, Zips and Import_errors in zip Format.

 

[Dick7Access]

Dick, I copied the csv to an Access mdb.
There were 2 import errors.
I am attaching the database, with 2 tables, Zips and Import_errors in zip Format.

Super, Thank you so much. How did you get all the leading zero's to show up?

 

[Dick7Access]

Dick, I copied the csv to an Access mdb.
There were 2 import errors.
I am attaching the database, with 2 tables, Zips and Import_errors in zip Format.

That will service my db I am working on just find, but when I get brave I think I will work on getting the cites to populate the city field automatically since you sent the cites also. I am not that brave yer!!

 

[jdraw]

Well, I only looked at the file briefly. It has Zip code and the major city. It also has lat/long coordinates (my guess is these represent the centroid of the zipcode area) - could be useful in mapping with Google Maps etc

I see no issue with identifying zipcode, majorcity, state (and possibly lat/long) in your table.

 

[Dick7Access]

Well, I only looked at the file briefly. It has Zip code and the major city. It also has lat/long coordinates (my guess is these represent the centroid of the zipcode area) - could be useful in mapping with Google Maps etc

I see no issue with identifying zipcode, majorcity, state (and possibly lat/long) in your table.

I see no issue either. It is my coding ability that is the issue. It would be nice to pick a zip from the combo and have it bring up the city in auto fill, but I am not sure I want to spend the time studying how to code it. Maybe on the next version.

 

[jdraw]

Fair enough, but putting a combo on a form, and setting its Rowsource to a query based on a table (to get just a few fields - you don't need them all) and then setting the combos properties is not a major undertaking.
But you know your time and skills and priorities.

Good luck.

Lots of combo tutorials at http://www.techonthenet.com/access/comboboxes/

 

[Dick7Access]

Fair enough, but putting a combo on a form, and setting its Rowsource to a query based on a table (to get just a few fields - you don't need them all) and then setting the combos properties is not a major undertaking.
But you know your time and skills and priorities.

Good luck.

Lots of combo tutorials at http://www.techonthenet.com/access/comboboxes/

Your right and it might be fun on the next version. In fact I even see some possibilities with coordinates. I have a db now that I can pull up a map from the closest interstates on where I have a meeting.