Hi,
Can you not just "Save as txt (tab-delimited)" in Excel , and then
have mySQL read it into a table(s) via batch mode? Am I
misunderstanding your problem?
-----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 6:28 AM
To: [EMAIL PROTECTED]
Subject: Re: Fw: Upload Excel (xls) to MySql
I create admin page, where user upload Excel file (xls) to server with
some
price.
In server I need transfer this file to MySQL table.
I need convert an Excel file in servlet on the host server.
I don't have access to properties of host server.
Server support servlet 2.2 and JDBC with MySQL JDBC bridge.
----- Original Message -----
From: Purav <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 2:07 PM
Subject: Re: Fw: Upload Excel (xls) to MySql
> I ddon't get you.. can you please explain in detail. Also what's ur
> developement env?
>
>
> _____
>
> 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 4:31 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Fw: Upload Excel (xls) to MySql
>
>
> I don't understand how I set up ann Excel datasource in hosting
server
odbc
> datasources!
> or may I setup odbc datasources from servlet???
>
> > why don't u just set up ann Excel datasource in your odbc
datasources
and
> > use JDBC to transfer data from the excel sheet to the mysql db?
> > ----- Original Message -----
> > From: "Kalashnikov D.V." <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Monday, August 06, 2001 10:20 AM
> > Subject: Fw: 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
> > >
> >
> >
>
______________________________________________________________________
_____
> > 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
___________________________________________________________________________
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
