Adam Morton
asked on
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
TIA
Amanda
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This wasn't really what I was after, but thanks for the comment.
ASKER