Hi thanks for your solutions, its working fine. but need to add value for element and also in attribute. for eg:

<cac:LegalMonetaryTotal>

...

Got the solutions..

Thanks

Here my sp code ,

its showing error like this :

--------------------------------

(95 row(s) affected)

create table ##tname( UnderwritingOld DECIMAL(9,2), LeaseAbstract DECIMAL(9,2), Accounting DECIMAL(9,2), HighYieldInvestments DECIMAL(9,2), AssetSummaryGroup DECIMAL(9,2), OriginationUnderwritingGroup DECIMAL(9,2), PortfolioUnderwritingGroup DECIMAL(9,2),...

HI thanks for your reply.... its working good..

But i had some issues on thats..

here i have attached the sample xls sheet.

in that i need to insert these rows as columns...

HI thanks for your reply.... its working good..

But i had some issues on thats..

here i have attached the sample xls sheet.

in that i need to insert these rows as columns...