XML to DataSet

[tshad]

I have an xml file that turns out to be an excel 2007 file.

It has 16 tables and one is a data table that has all the data in it but
they don't see to be segmented by row. I do know that there are about 12
columns and 90 rows..

Is there an easy way to read this into a database and come up with one table
that just has one table with normal rows and columns. Excel reads it fine
and you have a table with 90 rows of 12 columns.

Thanks,

Tom

 

[tshad]

You mean it's an xlsx file? If so, why not just use ADO.NET?

No. It is an xml file that obviously was build from excel. It starts out:

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-comffice:spreadsheet"
xmlns="urn:schemas-microsoft-comfficeffice"
xmlns:x="urn:schemas-microsoft-comffice:excel"
xmlns:ss="urn:schemas-microsoft-comffice:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">

Tom