actually one procedure is there for validating(checking for sheet names and for columns in sheet) excel and import data by using OPENROWSET('Microsoft.Ace.OLEDB.12.0').

and it split the data into multiple tables.

this procedure is invoked by .net application, in application i got this error message.

and now i tried from sql server management studio, it runs properly

but from application it throughs error messge...