Madeswaran Pachiyappan

From Security side,is there any advantage of using AJAX over other technology.

Hi,
How to generate multiple excel files based on HTML table values.
I want to generate Excel file for each <tr></tr>.Pls kindly give me suggestion as i am new to JSP.

Hi,
I successfully invoked some exe application through JSP.Using Runtime Class.Now,the Problem is ...
I want to know,whether the application is already invoked by other User.
if so,i want to through some message to current invoker.
pls,.It's very urgent...help me...

It seems few tools are available to import data from Excel to databases namely oracle, MS Sql, MySql etc....

Hope The following links may help you in accomplishing your requirement..

http://www.4tops.com/excelimport.htm
http://www.macupdate.com/info.php/id/7119
http://www.devshed.com/c/a/MySQL/Using-Navicat-to-Import-Data-into-MySQL/
http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/model/package-summary.html

Hi Vikrama,
What Jeanne Boyarsky told is exactly correct...


U can use-- sun.jdbc.odbc.JdbcOdbcDriver() where DSN pointing to Excel.
other wise
Apache giving a excellent package for Manipulation of Excel Data.ie..POI.
I too suggest for POI.

Hi,
Two things U want to check.

1) Ensure that classes12.zip or jar file is set in classpath.
Go to command Prompt and type "set classpath" and enter.Now see that Ur classes12.zip or jar file is in classpath.
2) Use
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
instead of Class.forName
Enjoy.....

Check the DSN Username and Password.Also Check the ODBCAD32,where the authenticity is through SQL Server Authentication.And Client Configuration is through TCP/IP.