Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 379
  • Last Modified:

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
0
HbugProject
Asked:
HbugProject
  • 2
1 Solution
 
Aaron ShiloChief 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now