View XML data as a table [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

开发者_Python百科 We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 2 years ago.

Improve this question

Is there a way I can use Visual Studio to view my XML data in a tabular structure by applying the appropriate XSD to it?

Are there any other tools I can easily use for this purpose? PS: I need this for a one time use.

---

Use Excel to view the XML document, as Oded mentioned.

If you're using Excel 2003, click on Data->XML->Import, and select the XML you'd like to view. Excel will ask you which cell to start the import from, and then populate the spreadsheet with the XML data.

---

Excel has surprisingly good XML support.

It will even generate the XSD internally if needed.

---

There is an option for this in XMLSpy 2011. A fully functional, 30 day trial is available for download here.

---

You can do this in SQL server quite easily using the FOR XML functionality.

A simple adaptation of the code from my answers to these questions would suffice:

• fastest Import of a csv to a database table

• How can I use single query to insert multiple records from Dataset into SQL Server 2005?

---

I'm not sure this answers your question, but I've had plenty of luck opening xml files in Firefox, copying and pasting the result into Notepad, and then importing the text file as a tab delimited file into Excel.

Probably an easier way to do that, but it works for me.