xml transformation question

-00Eric Clapton wrote:
[color=blue]
> How can I use the XML and XSLT to transfer data from CSV to SQL server?[/color]

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.
Ask in a data base group how to import the CSV data into your data base.


--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

Hello!
[color=blue]
> -00Eric Clapton wrote:
>[color=green]
>> How can I use the XML and XSLT to transfer data from CSV to SQL server?[/color]
>
> 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.[/color]

But it is possible to write custom XmlReader-s that simulate XML for
CSV-Files.
[color=blue]
> 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.[/color]

This should be possible with Microsoft Access...



--
Pascal Schmitt

Pascal Schmitt wrote:
[color=blue][color=green]
>> 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.[/color]
>
> But it is possible to write custom XmlReader-s that simulate XML for
> CSV-Files.[/color]

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/

I am just curious. What are the uses of XML and XSLT?


"Martin Honnen" <mahotrash@yahoo.de> wrote in message
news:OtUgP82yFHA.3860@TK2MSFTNGP09.phx.gbl...[color=blue]
>
>
> Pascal Schmitt wrote:
>[color=green][color=darkred]
>>> 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.[/color]
>>
>> But it is possible to write custom XmlReader-s that simulate XML for
>> CSV-Files.[/color]
>
> 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/[/color]

-00Eric Clapton wrote:[color=blue]
> I am just curious. What are the uses of XML and XSLT?[/color]

Well... XML is just a "language" to exchange Tree-like data structures.
As XML is a W3C-"standard", there exist many parsers for nearly every
platform wich makes the use easier - you can concentrate on using the
data instead of parsing some custom file format.

XSLT is used to transform one XML tree into another. Thus you can export
for example WordML from Microsoft Word 2003 and transform it into any
XML-based format you want (DocBook, XHTML, OpenDocument).


--
Pascal Schmitt