Another approach would be to use one of the Java components that knows how
to read Excel documents.
You might look at Formula One and or OutsideIn from Inso (OutsideIn was
bundled as part of Oracle's
InterMedia product).
These might provide an option other than JDBC.
Dave Bolt
ATSC/SPAWAR ASAT Team
Bolt's Law of Bandwidth - There is always plenty of network bandwidth, just
none for you.
-----Original Message-----
From: Artem Babenko [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 03, 2000 10:58 AM
To: [EMAIL PROTECTED]
Subject: Re: read an excel file
H!
You have to install excel with odbc drive
Then you have to create DSN for your table
then using jdbc odbc bridge connect to table and read your data
bye
-----Original Message-----
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of sridhar r
Sent: Sunday, September 03, 2000 5:08 PM
To: [EMAIL PROTECTED]
Subject: read an excel file
Hi
Can anyone help me in how to read an excel file.I have
to get data in each cell which i have to update in the
database.
thanks in advance
__________________________________________________
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
http://mail.yahoo.com/
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
