XML - can i use it to replace .csv

[SQLScholar]

Hey all,

I am new to XML - tell you the truth, i only know the little i have read, and what people have told me.

Currently i have SQL being queried and exporting a CSV. But my boss wants formatting. Now with this program i can do what ever i want with text (should be able to create XML) but i have a few questions.

1) Do you think i am going down the right lines?
2) Can it be opened in excel?
3) why when i use this code

<xml	xmlns:rs='urn:schemas-microsoft-com:rowset'
	xmlns:z='#RowsetSchema'>

<rs:data>
	<z:row ContactName='Maria Anders'/>
	<z:row ContactName='Ana Trujillo'/>
	<z:row ContactName='Antonio Moreno'/>
	<!-- And so on -->
</rs:data>

</xml>

which i found on the net - it just opens it up in explorer, printing this code.

I am reasonably good with programming/sql but i am not really sure what/how/when to use XML.

TIA

Dan

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!