Importing XML Data into SQL Server - how to?
Posted on 2004-09-16
I'm working with SQL Server 2000, VB and XML.
My VB application is receiving an XML file (Standard MISMO Credit Report layout). What I need to do is import some fields (or all fields either way) from the XML file into my SQL Database to analyze. I'm new to XML so I do not know where to begin? How do I import data from an XML file into SQL tables? I do not want to store the XML file in my SQL tables but actually stored specific values from the XML file into specific fields in my tables....?