Error Checking in Excel
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

Some videos you may like

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
  •