City, State, Zip, Country list/script for sql server table

Question

I have been searching around for the best source for City, State, Zip, Country to use in an application. I have found the set at GeoNames.org and it seems very comprehensive. However there is not a simple import into SQL Server. I also believe the USPS has something similar.

Does anyone know a good reliable source that is easily imported into SQL Server for this information? Or maybe even some better Googling terms?

Answer 1

Why can't you just get the CSV files and bulk-load them into your data base. How much simpler do you want?

Answer 2

There is a script to load data from geonames in a blog I wrote a while ago. Hopefully it helps.

SQL Server Zipcode Latitude/Longitude proximity distance search