Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Importing XML Data into SQL Server - how to?

Posted on 2004-09-16
3
Medium Priority
?
651 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 26

Accepted Solution

by:
rdcpro earned 1200 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

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
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…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

722 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