How to download City/Zip XML into SQL Server Table
Posted on 2011-03-22
Hello all. I am attempting to update some older processes here at our office. We are converting our older VFP databases to SQL Server. I am a newbie to both .NET programming and SQL server, though I have been working with VFP databases and code for years. We currently manually maintain city information in a VFP table. I would like to automate the process by using a XML file and a nightly table update. My goal is to get an official XML file of all city/zip combinations from USPS or SBA.gov or equivalent, and write VB to run nightly and update a SQL table on our servers. Does this make sense? How can I go about this?