Hi Eric
I have tried that using JDBC-ODBC bridge. But the requirement is
that I have to read an Excel file on Solaris system without the JDBC-ODBC
bridge.
Please reply
Sateesh
> ----------
> From: eric mabo[SMTP:[EMAIL PROTECTED]]
> Reply To: A mailing list for discussion about Sun Microsystem's Java
> Servlet API Technology.
> 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
