JXL科学计数法?
String paths =path;
InputStream isfile = new FileInputStream(paths);
jxl.Workbook rwb = Workbook.getWorkbook(isfile);
Sheet rsfile = rwb.getSheet(0);
String sheetnm = rsfile.getName();
Cell c0 = rsfile.getCell(0,0);
mobile= c0.getContents();
String strSQL_temp;
strSQL_temp="insert into T (mobile) "+
"select "+mobile+" from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=\""+path+"\";Extended Properties=Excel 5.0')..."+sheetnm+"$ where "+mobile+" is not null";
大家好,请问我用这种方式将EXCEL数据导入MSSQL2000中时,如果EXCEL中mobile类型置为常规时,保存到数据库后,变成了科学计算法,请问我要怎样才可以使其恢复正常?是在代码中,还是在数据库中?