Madeswaran Pachiyappan

Greenhorn
+ Follow
since Jun 29, 2004
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by 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.
19 years ago
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...
19 years ago
JSP
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

20 years ago
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.