• Post Reply Bookmark Topic Watch Topic
  • New Topic

Update data to excel  RSS feed

 
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
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!