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
posted 16 years ago
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).]
posted 15 years ago
after selecting the driver and the excel file see to that the read only check box is deselected in options panel then it works
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads