Solved

Importing XML Data into SQL Server - how to?

Posted on 2004-09-16
3
645 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

The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API (http://dictionary.reference.com/browse/API?s=t) has made its way into the popular lexicon of the English language.  A few years ago, …
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

932 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now