ΒΆ
Load the Zip Code (ZipCode) Database records for use with Store Locator
Open the Translate Sheet in Google and switch to the ZipCodeDb tab
https://docs.google.com/spreadsheets/d/1zo2TiLLFFzGE3X8uCO0P3tdfwpPD8U8bkjXh091Er0A/edit#gid=188344983
Copy the contents of the last column (SQL)
Paste it into a new query window for the database
Select half the rows at a time (about 40k) and run them
individually, if you try to run all 80k rows it will refuse
Ensure that the Geography.Address table is updated with Latitude and
Longitude values for individual stores