Pam/Chris -
Attached is what should be an updated zip code data file with all the fields needed to import into Patriot tlkZips.
This file was taken from https://public.opendatasoft.com and contained everything we need except LongRadian and and LatRadian which are calculated like this...
LongRadian = Longitude*PI()/180
LatRadian = Latitude*PI()/180
PI() = 3.14159265358979 and is an available function in both Excel and SQL.
You should be able to blow away the current rows in tlkZips and import this data set in its place and be good.
Thanks,
Scott