Hi all,
One more point to add.
In the excel file u have to select all the required rows and colums
and define a name.
(select Insert/Name/Define.. menu)
The "name" which have given will act as the table.
The column names will be the contents of the first row.
Rgds
-Deepu
-----Original Message-----
From: eric mabo [SMTP:[EMAIL PROTECTED]]
Sent: Monday, August 07, 2000 5:34 PM
To: [EMAIL PROTECTED]
Subject: Re: Reading an Excel file
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
___________________________________________________________________________
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
