Its a great article.

It works fine with Windows Server 2003, but not with Windows Server 2008 and SQL Server 2008. I have Office 2007 installed.

Can you suggest any work around..

Thanks...

Thanks for ur prompt response.

I receive XML Spreadsheet 2003 with xls extension and the WorkSheetName is a Space.

This spreadsheet is generated by another system, which is not under the control...

This is a great tool.

Only problem is, it asks for WorksheetName, which in my case is blank.

Can u please suggest me what changes will it require to handle this situation?

Check out this link. It is just one step quick way.

http://www.mssqltips.com/tip.asp?tip=1316