Plz help me

ritesh_ch23 · #1 (**permalink**) July 18th, 2006, 08:49 AM

hi,
I want to import data from excel sheet to mysql using JSP.. But i am not getting any information about how to do it. So any body can help regarding this mater.

I want to do it from jsp page. SO plz help me..

panacea · #2 (**permalink**) July 18th, 2006, 10:46 PM

Jakarta POI allows you to programmatically read Microsoft Office formats, such as Microsoft Excel. http://jakarta.apache.org/poi/

Once you've read them into your Java runtime, use JDBC to output the data to MySQL. I don't see any reason why you should do this in JSP. You should keep this kind of implementation in Java classes.

Jon Emerson
http://blogs.adobe.com/jon.emerson/

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
plz.....plz solve out my problem....	kethireddy435	ASP.NET 1.x and 2.0 Application Design	1	October 4th, 2007 12:56 PM
plz tell me	flowertear	Pro Visual Basic 2005	2	November 28th, 2006 08:30 PM
Plz plz someone help	beetle_jaipur	CSS Cascading Style Sheets	3	March 26th, 2006 05:37 AM
Need Help someone plz help !	augustine	SQL Server 2000	4	April 18th, 2005 12:45 PM
Help me plz	waqaraziz	VB.NET 2002/2003 Basics	1	March 19th, 2005 04:40 PM