I find some way to upload the Excel files to MySQL table through servlet:
1. Install on host server MyODBC v2.50 from www.mysql.com (working both on
Windows or Unix(Linux)).
2. Configure DNS for working with upload file.
3. In servlet connet to xls file through JDBC-ODBC.
But i havn't tried yet - install on host server MyODBC payable service.
Had somebody tried to do so?
----- Original Message -----
From: John Slaman <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 4:09 PM
Subject: Re: Upload Excel (xls) to MySql
> About 18 months ago I was on a project where we wanted to upload xls files
> into Microsoft's SQL Server database.
> The solution we used was a two step process:
> a) Upload the files and put it onto the server's hard drive.
> b) Fire a trigger in MS SQL Server to import the file (This used TSQL
code -
> which is just Microsoft's SQL Server scripting language - conceptually
> similar to PL/SQL).
>
> The issue here was the DBA's could go figure how to get data into/out-of
the
> database using utilities that already existed in the database engine. (MS
> SQL Server knows how to import an .xls file - and MySQL may know too);
while
> the Java and HTML guys worry about creating the necessary GUI and programs
> to upload a file through a browser (also something that contains a known
> solution). At one point we talked about the java code firing off a .bat
> file - to trigger appropriate scripts. But I believe the final
> implementation was to just create a record in the database containing the
> file name and date/time uploaded; and inserting the record triggered the
> database trigger - which then went and read the file from the server &
> imported it into the database.
>
>
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's Java Servlet
API
> Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of Kalashnikov
> D.V.
> Sent: Monday, August 06, 2001 3:47 AM
> 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
>
>
___________________________________________________________________________
> 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
