Stephen,
I'm not 100% sure what your question is. When I pull that XML into a DataSet, I get 18 tables. DataSet.Tables[8].TableName is "Worksheet". And it looks like to me that each "node" (as you're calling them) has a related table that is the worksheet for that node? Does this spreadsheet have a WorkSheet for each of these nodes?
I don't know a whole heckuva lot about Excel with .NET (we're doing stuff with it in our app, but it's not been my area and so I haven't worked with it) ... but I guess I don't really understand what you're trying to ask.
~~Bonnie
>I was just given the excel file from hell. It's designed to go to a printer and allow them to bring a pricing book for our products.
>
>In general we assemble components together that have a few million combinations. Anyway, this pricing list is very close to what I need to update a data table.
>
>This will be done on a SQL Server / ASP.NET C# based system.
>
>Here is the file :
>
www.midsouthautos.com/PriceTest.xml>
>when I bring it into a ds, I can't seem to assocaite to a specific table the nodes of 100, 221, 230_231,..... I was expecting them to be in a separate table?
>
>TIA.
>
>__Stephen