I have a spreadsheet with various building information but it only has city and state. I was able to create a .qry file to get external data from a particular location, but it just pulls all the info - I just want to pull out the first zip (it doesn't have to be exactly correct). The idea is that I will then use a zip code to MSA (metropolitan statistical area) lookup table.
I have:
City & State
I want to query for:
The a zip code in said city and state
The contents of the .qry file:
Code:
WEB
1
http://zipcodes.addresses.com/results.php?ReportType=42&qc=["City","Enter the Search Term:"]&qi=0&qk=100&qs=["State","Enter the Search Term:"]
Selection=10
Formatting=None
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=True
I played with the "Selection =" and "SingleBlockTextImport=" with no success. Available documentation for the parameters & flags for such a query is sporadic at best.
This is what I'm getting after using the above query method:
Click for full size -
Uploaded with plasq's Skitch
What I really want is just the 92801 returned.
All help is greatly appreciated. Have a good day.