SQL_MAN_4U
asked on
Importing XML Data into SQL Server - how to?
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....?
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....?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.