import zipcodes

[Guest]

I have an Excel spreadsheet that has a listing of zipcodes, towns, and counties. Is there anyway to import this to my MS Access database so that when I enter a city, the state, zipcode and county will automatically populate so I don't have to type them in each time? For example, whenever I put in city "Harwich", it would auto populate the fields for state with "MA", zipcode field with "02645", and county "Barnstable".
I have looked at the help icon but it didn't make sense to me. Any suggestions??

 

[mark]

Check out this article:

http://www.mvps.org/access/forms/frm0009.htm

-----Original Message-----
I have an Excel spreadsheet that has a listing of

zipcodes, towns, and counties. Is there anyway to import
this to my MS Access database so that when I enter a city,
the state, zipcode and county will automatically populate
so I don't have to type them in each time? For example,
whenever I put in city "Harwich", it would auto populate
the fields for state with "MA", zipcode field
with "02645", and county "Barnstable".

 

[Mae]

It's helpful to notice that the site listed shows how to
get the city and state from the zipcode, not the other way
around. A single city can have several zipcodes, so
populating the city and having the zipcode autofill won't
work. If you have the zipcode though, you can easily get
the city and state. (In rare cases, two cities can have
the same zip, but one city with two zips is a much more
likely scenario.)

 

[L. T. Portella]

I am a real newbie. Just how can I use the code that appears in the site you
recommended. In my case I have an access 2000 table and would like to type
in the code and get the city and state fields populated. Any help you can
lend me will bedeeply appreciated.
(e-mail address removed)

 

[Guest]

ok. everyone is right. so how do i do it? if i put in the zipcode, how do i get the city, state, and county to auto populate? i have a spreadsheet which breaks it all down by zipcode. how can i get that information into the Access database without having to manually enter it all each time? For example, every time i enter 02601, the city Hyannis, state MA, and county Barnstable fill in? Please help... Thanks./