• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Unable to insert data into an Excel Sheet

 
Rakesh Keerthi
Ranch Hand
Posts: 152
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I've the below HTML Page.



from this page i'm trying to add data into Excel sheet using the below jsp.



but when i run this i'm getting the below Exception.


But when i add an extra '?' in my prepared statement, i'm getting the below Exception.



please let me know where am i going wrong.

and my excel sheet is of the below column names.



Thanks
 
Ulf Dittmer
Rancher
Posts: 42969
73
  • Likes 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't know anything about this problem specifically, but I would urge you to stop using both the JDBC/OBDC bridge as well as JDBC with Excel. Apache POI is an excellent library for dealing with Excel files.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic