Hai,

I have imported a excel file into sql server table through OpenRowset concept in sql server. But i struck with some problem, it is when is execute the query, sql server reported an error, b'coz the excel file is opened mode. I want to know how to fetch those values from excel, when it is opened mode, please reply i am working on that