-00Eric Clapton wrote:

> How can I use the XML and XSLT to transfer data from CSV to SQL server?

> -00Eric Clapton wrote:
>
>> How can I use the XML and XSLT to transfer data from CSV to SQL server?
>
> XSLT transforms an input tree into a result tree which is then
> serialized as XML or as HTML or as text. The input tree is usually built
> by parsing some input XML.

> With that standard approach I don't see XSLT helpful to get data in a
> CSV format into an SQL data base server, there are certainly ways to
> import that CSV data into a data base without using XSLT.

Pascal Schmitt wrote:

>> XSLT transforms an input tree into a result tree which is then
>> serialized as XML or as HTML or as text. The input tree is usually
>> built by parsing some input XML.
>
> But it is possible to write custom XmlReader-s that simulate XML for
> CSV-Files.

"Martin Honnen" <mahotrash@yahoo.de> wrote in message
news:OtUgP82yFHA.3860@TK2MSFTNGP09.phx.gbl...
>
>
> Pascal Schmitt wrote:
>
>>> XSLT transforms an input tree into a result tree which is then
>>> serialized as XML or as HTML or as text. The input tree is usually built
>>> by parsing some input XML.
>>
>> But it is possible to write custom XmlReader-s that simulate XML for
>> CSV-Files.
>
> That is possible but I am not sure why anyone would want to do that or
> need that to get a CSV imported into a relational data base.
>
> --
>
> Martin Honnen --- MVP XML
> http://JavaScript.FAQTs.com/

-00Eric Clapton wrote:
> I am just curious. What are the uses of XML and XSLT?