hello, all I am trying to insert rows from Excel sheet into SQL database by browsing Excel file in java(JSP). I can insert rows using ODBC connetion. But using odbc user should give DSN in program. I need to insert rows by Browsing file to make it user friendly.i.e user should browse the existing excel file and then on submission of form, value should get insert into a database. please provide me the code snippet... thanx in advance
All 3 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.