Oledbdataadapter not updating

And i'm afraid i can't say what caused the problem to dissapear.I'm guessing it must either have been after some windows update or possibly after rebooting a few times.Thanks for your replay i have tried but some error is comeing ,i have written as fallows, String s Connection String = "Provider=Microsoft. OLEDB.4.0;" "Data Source=" path ";" "Extended Properties='Excel 8.0; HDR=NO'"; Ole Db Connection obj Conn = new Ole Db Connection(s Connection String); obj Conn. OLEDB.4.0; Data Source=C:\Temp\Book1.xls; Extended Properties='Excel 8.0; HDR=NO'"; Ole Db Connection obj Conn = new Ole Db Connection(s Connection String); obj Conn. OLEDB.4.0; Data Source=C:\Temp\Book1.xls; Extended Properties='Excel 8.0; HDR=NO'"; Ole Db Connection obj Conn = new Ole Db Connection(s Connection String); obj Conn.

Another example below: "UPDATE [Sheet1$E5: E5] set F1=999" It will update E1. A week ago i continued working on this project and no longer seem to be having this issue.

Execute Non Query(); It works only for F1 column, Not working for F2 F3 F4...

columns command String = "UPDATE [MBS$A2: A2] SET F1=123456"; cmd Excel. Execute Non Query(); command String = "UPDATE [MBS$A4: A4] SET F2='hello'"; cmd Excel. Execute Non Query(); command String = "UPDATE [MBS$B5: B5] SET F2='goodby'"; cmd Excel. Execute Non Query(); Please tell me syntax to update F2 F3 columns cells. Old post so probably not necessary anymore but here's the answer anyway: Your "destination range" is defined as "[MBS$A2: A2]" which simply selects the range "A2: A2" in sheet "MBS" for update.

Another example below: "UPDATE [Sheet1$E5: E5] set F1=999" It will update E1. As long as my xlsm file is closed it only updates the first row.

Appreciate if someone can help me how to solve this issue. When the file is open when I run my program it works fine ...

I wish i could give you a sufficient answer but i'm afraid my knowlegde is lacking ...