CODEWITHSUNDEEP
xmlsql-server-2005excel
happysmile
happysmile

Reputation: 7777

how to convert data from xml file to excel sheet

1: Is there any way to covert the xml data into Excel workSheet?

2: Also from database (sql server 2005 ) to an Excel worksheet?

Upvotes: 0

Views: 6946

Answers (2)

Faiz
Faiz

Reputation: 5453

This is a straight forward one, well documented in Microsoft site http://office.microsoft.com/en-us/excel/HP010423511033.aspx

If you are talking about doing it programatically, I think the first answer is a good start.

Upvotes: 1

David Basarab
David Basarab

Reputation: 73301

You can export data from a Sql Server database to excel. See this link and this one.

As for an xml file, you can easily just open the xml file in Excel. Depending on the format it should open up for you fine.

Upvotes: 1

Related Questions