title: Import Open Excel File in Sql Server
body: <p>I am running into an issue, while I import an excel file into sql server 2005 using OpenRowSet, it works fine when excel file is closed, If excel file is open it gives an error message.
  I have an excel file which is being updated 8 to 10 times in a minute by a third party software, I have to import this excel file into sql server 2005 very 10 seconds.</p>
  
  <p>Any help would be higly appriciated.........
  Thanks, Yogi</p>