Solved

Importing XML Data into SQL Server - how to?

Posted on 2004-09-16
3
646 Views
Last Modified: 2008-03-17
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....?
0
Comment
Question by:SQL_MAN_4U
3 Comments
 
LVL 26

Accepted Solution

by:
rdcpro earned 300 total points
ID: 12080938
I answered this a couple times in the last few days.  Take a look at these:

http://www.experts-exchange.com/Web/Web_Languages/XML/Q_21132963.html#12071281
and
http://www.experts-exchange.com/Web/Web_Languages/XML/Q_21133476.html

Lots of great info in SQL Book online and the SQL XML 3.0 help documentation!

Regards,
Mike Sharp
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Nessus Scan 1 71
SharePoint 2013 Blog Template 2 48
Test ddwrt:UserLookup 1 65
MS SQL Database Generating XML using query 21 44
The Client Need Led Us to RSS I recently had an investment company ask me how they might notify their constituents about their newsworthy publications.  Probably you would think "Facebook" or "Twitter" but this is an interesting client.  Their cons…
Browsing the questions asked to the Experts of this forum, you will be amazed to see how many times people are headaching about monster regular expressions (regex) to select that specific part of some HTML or XML file they want to extract. The examp…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question