Hi Sateesh:
Eventhough I am a novice here, I did this just yesterday and it worked.
The trick is to use a JDBC-ODBC bridge(JDBC API).
1.Go to the control panel of you Win98/NT and double-click ODBC icon.
2.Click on Add
3.Select the MS Excel ODBC and click OK
4.Write the name of your excel file and add a description
5.Follow the rest of the instructions till finish.
.
.
.
11.Using the JDBC API write an application to connect to your excel file.
You can use SQL commants in your application to manipulate your database as
usual.

I hope this answers your question.
Have fun!!
Eric





>From: Sateeshkumar_Karnam <[EMAIL PROTECTED]>
>Reply-To: "A mailing list for discussion about Sun Microsystem's Java
>        Servlet API Technology." <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Reading an Excel file
>Date: Mon, 7 Aug 2000 15:08:30 +0530
>
>Hello
>         Please let me any information about reading an Excel file using
>any
>Java API(Even any third party tools).
>
>
>Thanks in advance
>Sateesh
>
>___________________________________________________________________________
>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

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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

Reply via email to