Is it even possible?!? Importing web data..

[kenny_roswell]

Assistance greatly needed. I have to enter every U.S. zip code into a
address locater http://www.riccar.com/where-to-buy/vacuums/. (Look up
vacuum dealers). Currently I have an excel spread sheet with all th
zip codes for one state listed in column A. In column B, I manuall
enter the dealer names which the locator search returns. I input th
address in Column C. Can a web query or macro be designed to read th
zip codes in Column A and populate the dealer and addresses in Column
and C.? Any suggestions would be greatly appreciated.

thanks,
frustrated in N

 

[Guest]

Sounds like you would have to know how the address in question correlates to
the geographic area that the zip code covers. From your description, I'm not
sure you have that piece of info.

Example: if the address is 255 W 94th St., NY, NY the only way you could
associate it with a zip code is to know which zip code encompasses the
physical location of that building. I know you can enter one address at a
time at usps.gov and have the zip returned.

 

[kwstroud]

That sounds like a perfect job for a script writing software that we
use called Foxtrot. Check out Foxtrotone.com