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
