Zipcode lookup? - Page 2
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Zipcode lookup?

  1. #11
    Board Regular
    Join Date
    Mar 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    It may be easier to just walk you through the extraction of the data, as it takes up a 3.3 MB file. In the Speedkeys Dir. that you created (probably c:program filesSpeedkey) there is an MS Access file called ZIPCODES. If you have access, and click on that, there is a table called ZIPS.....click on that to open it up.....44,000 lines (all of the cities)....hit FILE:SAVE ASEXPORT: and choose, TO AN EXTERNAL FILEDATABASE. CHange SAVE AS TYPE from MS ACCESS to MS EXCEL and click Export
    Now you have the data in Excel, where you can do a vlookup....hope this helps

  2. #12
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Helps? Yes and no. Yes, in that it lists the code, no in that it has the multiple ones for the cities (which I knew it would, but still...)

    :shrug: I guess I'll just play around with it.

    Thanks!
    Kristy

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com