<div>
you can try openxml or xpath to do that.
</div>


<div>
You can use <b>OPENROWSET </b> or <b>OPENXML</b><br />
<br />
Refer below examples:<br />
<a href="https://www.mssqltips.com/sqlservertip/2899/importing-and-processing-data-from-xml-files-into-sql-server-tables/" rel="ugc">https://www.mssqltips.com/sqlservertip/2899/importing-and-processing-data-from-xml-files-into-sql-server-tables/</a>
</div>


You can use OPENROWSET or OPENXML

Refer below examples:
https://www.mssqltips.com/sqlservertip/2899/importing-and-processing-data-from-xml-files-into-sql-server-tables/ [https://www.mssqltips.com/sqlservertip/2899/importing-and-processing-data-from-xml-files-into-sql-server-tables/]

<div>
have you checked this link: <a href="https://support.microsoft.com/en-us/help/316005/how-to-import-xml-into-sql-server-with-the-xml-bulk-load-component" rel="ugc nofollow">https://support.microsoft.<wbr />com/en-us/<wbr />help/31600<wbr />5/how-to-i<wbr />mport-xml-<wbr />into-sql-s<wbr />erver-with<wbr />-the-xml-b<wbr />ulk-load-c<wbr />omponent </a>
</div>


have you checked this link: https://support.microsoft.com/en-us/help/316005/how-to-import-xml-into-sql-server-with-the-xml-bulk-load-component [https://support.microsoft.com/en-us/help/316005/how-to-import-xml-into-sql-server-with-the-xml-bulk-load-component]

<div>
if you want to automate the importing process, you probably can use <b>SSIS </b>or build a <b>custom ETL program</b> for that purposes.
</div>


if you want to automate the importing process, you probably can use SSIS or build a custom ETL program for that purposes.

<div>
Hi Naitik Gamit,<br />
<br />
The solution you suggested seems good but I get confused with the line below. &nbsp;My xml files does not have the &quot;ROOT&quot; tag, it has page headers, totals, etc..<br />
<br />
Help Taz<br />
<br />
SELECT CustomerID, CustomerName, Address<br />
FROM OPENXML(@hDoc, 'ROOT/Customers/Customer')<wbr />
</div>


Hi Naitik Gamit,

The solution you suggested seems good but I get confused with the line below.  My xml files does not have the "ROOT" tag, it has page headers, totals, etc..

Help Taz

SELECT CustomerID, CustomerName, Address
FROM OPENXML(@hDoc, 'ROOT/Customers/Customer')

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I've never worked with xml files. &nbsp;I'm getting 30+ files with data that I need to load into sql table. &nbsp;How do I do that<br />
<br />
Thanks Taz
</div>
</div>


Hi,

I've never worked with xml files.  I'm getting 30+ files with data that I need to load into sql table.  How do I do that

Thanks Taz

xml files

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.