<div>
I'm using the MSXML library using the DOM data structure and DOM transformation to implement the XSL on the XML.
</div>


I'm using the MSXML library using the DOM data structure and DOM transformation to implement the XSL on the XML.

<div>
If all you want to do is save the XML document in SQL Server than all you need is to write a Stored Procedure and pass the XML document as a parameter or use the Stream object.<br />
<br />
Anthony
</div>


If all you want to do is save the XML document in SQL Server than all you need is to write a Stored Procedure and pass the XML document as a parameter or use the Stream object.

Anthony

<div>
i think the best way is to open a recordset using the XMl file &amp;&nbsp;then execute the insert into statement to insert in the SQL Server.
</div>


i think the best way is to open a recordset using the XMl file & then execute the insert into statement to insert in the SQL Server.

<div>
<div class="content wysiwyg-content">
Hi,<br />
&nbsp; &nbsp; I am using Visual Basic 6.0 and I have incoming XML documents that I want placing in a database. Currently the database is on MS SQL Server, though I may need to change this at a later date.<br />
&nbsp; &nbsp; I can think of plenty of ways of importing the XML into a database, but I'd like to ask if anyone has an efficient way of doing this.<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; The current method I'm using is turning XML into an SQL Queries. This means that the query can now be made on any database. I can use either XSL or an object library (currently using XSL) to convert the XML to SQL Queries.<br />
&nbsp; &nbsp; And then connecting to the MS SQL Server and executing the query.<br />
<br />
&nbsp; &nbsp; Thanks
</div>
</div>


Hi,
    I am using Visual Basic 6.0 and I have incoming XML documents that I want placing in a database. Currently the database is on MS SQL Server, though I may need to change this at a later date.
    I can think of plenty of ways of importing the XML into a database, but I'd like to ask if anyone has an efficient way of doing this.
    
    The current method I'm using is turning XML into an SQL Queries. This means that the query can now be made on any database. I can use either XSL or an object library (currently using XSL) to convert the XML to SQL Queries.
    And then connecting to the MS SQL Server and executing the query.

    Thanks

XML to MS SQL Server

Delphi is the most powerful Object Pascal IDE and component library for cross-platform Native App Development with flexible Cloud services and broad IoT connectivity. It provides powerful VCL controls for Windows 10 and enables FMX development for Windows, Mac and Mobile. Delphi is your choice for ultrafast Enterprise Strong Development™. Look for increased memory for large projects, extended multi-monitor support, improved Object Inspector and much more. Delphi is 5x faster for development and deployment across multiple desktop, mobile, cloud and database platforms including 32-bit and 64-bit Windows 10.

Delphi

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.