hi all
any body help me for my problem in my code
i need to update my sql from excel sheet. but my excel sheet must be open all time, coz it connected with server to update value into this excel sheet.

and i put this code in calc event into this excel sheet:

SqlCom.CommandText = "Update DirectMarket Set DirectMarket.StockVolume=T2.Volume, from DirectMarket inner join (Select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=D:\test.xls;HDR=YES','SELECT * FROM [Sheet1$]')) T2 On DirectMarket.StockSymbol = t2.Symbol "

but this code ask me to close excel sheet to complete update data into SQL server.
i cant close file cose it updated all time.

so please i want to know how can i do update data while excel file is open ????

thank u so much for all.