XML to DataSet

  • Thread starter Thread starter tshad
  • Start date Start date
T

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
 
Mark Rae said:
You mean it's an xlsx file? If so, why not just use ADO.NET?
Click to expand...

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-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">

Tom
 
Back
Top