First download the xls file on the server. Then thru an ODBC bridge , read
the xls file and use an Insert Query to store the rows in a database.
_____
Purav Parekh
Team Leader-Projects
Studentsguild.com Pvt. Ltd
321/1, Shantinagar Housing Society,
Timber Market Road,
Pune- 411 042
INDIA.
Office : +91-20-4003350
Fax: +91-20-4003356
Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
http://www.studentsguild.com/reflex.html
http://www.studentsguild.com This e-mail, its content and any files
transmitted with it are intended
solely for the addressee(s) and may be legally privileged and/or
confidential. Access by any other party is unauthorised without the
express written permission of the sender. If you have received this e-mail
in
error you may not copy or use the contents, attachments or information in
any
way. Please destroy it and contact the sender via e-mail return. This
e-mail has been prepared using information believed by the author to be
reliable and
accurate, but Studentsguild Pvt. Ltd. makes no warranty as to accuracy or
completeness. In particular Studentsguild Pvt. Ltd. does not accept
responsibility for changes made to this e-mail after it was sent. Any
opinions expressed in this document are those of the author and do not
necessarily
reflect the opinions of Studentsguild Pvt. Ltd.
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet API
Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Kalashnikov
D.V.
Sent: Monday, August 06, 2001 1:38 PM
To: [EMAIL PROTECTED]
Subject: Re: Upload Excel (xls) to MySql
How I store it in Database?
do u have any example of storing xls file in Database?
>I would use JSP and Servlets.
>
>craete a GUI using the JSP file and create a service with a Servlet
>receiving the xsl file and storing it in the Database.
>
>/paTRiK
-----Original Message-----
From: Kalashnikov D.V. [mailto:[EMAIL PROTECTED]]
Sent: den 6 augusti 2001 09:47
To: [EMAIL PROTECTED]
Subject: Upload Excel (xls) to MySql
May be this some off-topic, but I can't find help in archive and Google.
What is the best way upload user xls file to MySql server using servlet or
jsp?
I need some help, how to decode xls file in servlet.
Any help will be greatly appreciated.
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
