How to download City/Zip XML into SQL Server Table

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?
TIA
Amanda
HbugProjectAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Aaron ShiloConnect With a Mentor Chief Database ArchitectCommented:
hi

read this guide by USPS for handeling the xml

http://www.usps.com/webtools/htm/Address-Information-v3-1.htm

you can allways load the XML into the database
read this guide for howto :
http://blog.sqlauthority.com/2009/02/13/sql-server-simple-example-of-reading-xml-file-using-t-sql/
0
 
HbugProjectAuthor Commented:
I contacted USPs, and they do not provide an XML file of this. Is there another source? I found some promising things on SBS.gov. Does anyone have any experience with this?
0
 
HbugProjectAuthor Commented:
This wasn't really what I was after, but thanks for the comment.
0
All Courses

From novice to tech pro — start learning today.