|
Yes you can.. you will need to pre-process the data some so that there is a single record per zip code. I would find it easiest to import all the data to Access and manipulate it. If you have the ability to create views and tables on SQL server it could also be done there.
You may want to assign zip codes to the 700 where it is missing.
Eric |