大家好!请问在用下面的SQL导入EXCEL数据至表T时,怎样使这一次导入EXCEL生成一从1开始递增的序号?
String sql="insert into T(a,b) " +
"select "+Product_Code+","+Product_Name+" from " +
"OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=\""+path+"\";Extended " +
"Properties=Excel 5.0')..."+sheetnm+"$ where "+se+" is not null";
String sql="insert into T(a,b) " +
"select "+Product_Code+","+Product_Name+" from " +
"OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=\""+path+"\";Extended " +
"Properties=Excel 5.0')..."+sheetnm+"$ where "+se+" is not null";
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货