Geek Answers Handbook

View XML data in a table

Can I use Visual Studio to view my XML data in a table structure by applying the appropriate XSD to it?

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

+4
source share
5 answers

Use Excel to view the XML document that Oded mentioned.

If you are using Excel 2003, click Data-> XML-> Import and select the XML that you want to view. Excel will ask you which cell will start the import, and then populate the table with XML data.

+2
source

Excel has amazingly good XML support.

It will even generate XSD if necessary.

+2
source

There is an XMLSpy 2011 option for this. A full functional 30-day trial is available for download here .

+1
source

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

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

+1
source

I'm not sure if this answers your question, but I was very lucky to open the xml files in Firefox, copy and paste the result into Notepad, and then import the text file as a tab delimited file into Excel.

This may be an easier way to do this, but it works for me.

0
source

More articles:


All Articles