• 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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic