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
Thomas Paul
mister krabs
Ranch Hand
Joined: May 05, 2000
Posts: 13974
posted
0
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).]
vijay aditya
Greenhorn
Joined: Jun 23, 2001
Posts: 2
posted
0
after selecting the driver and the excel file see to that the read only check box is deselected in options panel then it works
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
