Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Update data to excel

 
Naresh Babu
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13974
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Someone had a question like this. Do a search for Excel in this forum.
 
Naresh Babu
Greenhorn
Posts: 29
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!