try:Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
Connection conn = DriverManager.getConnection("jdbc:odbc:excel","sa","password") ;
Statement stmt = conn.createStatement() ;
String sSql = "insert into [Sheet1$](第一行第一列列名,第一行第二列列名,....)values('abc','def',....)" ;
stmt.executeUpdate(sSql) ;
Connection conn = DriverManager.getConnection("jdbc:odbc:excel","sa","password") ;
Statement stmt = conn.createStatement() ;
String sSql = "insert into [Sheet1$](第一行第一列列名,第一行第二列列名,....)values('abc','def',....)" ;
stmt.executeUpdate(sSql) ;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货