Hi ,
If u r using Excel Sheet to enter data in U r database .
There is one method u can use
1) Create The DSN for that excel sheet Control Panel ->Data Source ODBC
2) Write a simple JDBC Program to connect to the the Data Source
3 ) The Sheet Name will be the Table Name and Will be by default "$Sheet1"
or " Sheet$1"
Please Check it out it.. I did this thing long Time back.
Regards
Santosh Harnath
-----Original Message-----
From: Kalashnikov D.V. [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 1:17 PM
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
This e-mail and any files transmitted with it are for the sole use of the intended
recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message. Any unauthorised review, use, disclosure,
dissemination, forwarding, printing or copying of this email or any action taken in
reliance on this e-mail is strictly prohibited and may be unlawful.
Visit us at http://www.cognizant.com
___________________________________________________________________________
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
