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