When i try to update data in excel using st.executeUpdate("update [test$] set ENAME='updated' "); where st - statement object. I get exceptions as:Operation must be an updateable query. Is there wrong with syntax?? I also , tried to insert data into excel sheet.Its also giving me errors.Please, help me. Thanks
Joined: May 05, 2000
Someone had a question like this. Do a search for Excel in this forum.
Thanks! for the reply.I did a search.Btt,the topic included only retreival of data from excel.I want to know how to insert, update and delete data to excel using jdbc.Please , suggest me options where i can find this information. Thanks
[This message has been edited by Naresh Babu (edited March 24, 2001).]
Joined: Jun 23, 2001
after selecting the driver and the excel file see to that the read only check box is deselected in options panel then it works