xml transformation question

[-00Eric Clapton]

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

[Martin Honnen]

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

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

[Pascal Schmitt]

Hello!

-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.

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

This should be possible with Microsoft Access...

--
Pascal Schmitt

[Martin Honnen]

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]

I am just curious. What are the uses of XML and XSLT?
"Martin Honnen" <ma*******@yahoo.de> wrote in message
news:Ot**************@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/

[Pascal Schmitt]

-00Eric Clapton wrote:

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

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