You could enter everything but the city and state in excel, then import it all into access and run a query against a zip code/city/state database (which you'd have to buy, they can be had for ...

Various Count Functions in Excel. If your business uses spreadsheets, you may find it necessary to count the number of cells containing data in a worksheet. You might also need to determine how ...