goss
Active Member
- Joined
- Feb 2, 2004
- Messages
- 372
Hi all,
Using excel 2010.
I would like to see if I can come up with the same chart or better than the folks at the Wall Street Journal The Microeconomics Of Restaurant Letter Grades
I would like to use a web query to pull all restaurant inspection scores for New York City
Restaurant Inspection Information for New York City Department of Health and Mental Hygiene site
Restaurant Inspection Information
When I go the site, it lists the boroughs and I would have to click on each borough and then it lists several restaurants on each page and I have to keep advancing through 111 pages just to get the 2220 restaurants for the Bronx.
Does anyone know of a better way to get this information in one nice query to pull all information for all boroughs at once?
Using excel 2010.
I would like to see if I can come up with the same chart or better than the folks at the Wall Street Journal The Microeconomics Of Restaurant Letter Grades
I would like to use a web query to pull all restaurant inspection scores for New York City
Restaurant Inspection Information for New York City Department of Health and Mental Hygiene site
Restaurant Inspection Information
When I go the site, it lists the boroughs and I would have to click on each borough and then it lists several restaurants on each page and I have to keep advancing through 111 pages just to get the 2220 restaurants for the Bronx.
Does anyone know of a better way to get this information in one nice query to pull all information for all boroughs at once?