Thanks Rick. I was able to import file into an Access DB. Set up a Search form for Zip, State or City. Further then, because many at my location many don't have Access, I set up a link between Access and EXCEL 2010 and created a pivot table with slicers for State, City and Zip. Works very slick. Unfortunately, due to file size limitation, I am unable to upload either of the files even if Zipped.
Rick that is probably the best free zip code database. The only downside is the lat, lng is not that accurate. Working from the db you provided I updated the lat, lng to be more accurate you can get the new zip code database here.
If you don't need super accurate lat, lng the free database works great. It is off by about 5 miles for most zip codes.
Posting Permissions
Reply With Quote
Bookmarks