58问答库 > 将EXCEL里的数据(规定好格式)导入到MSSQL数据库的ＡＳＰ源码？

将EXCEL里的数据(规定好格式)导入到MSSQL数据库的ＡＳＰ源码？

2025-03-26 12:13:22

推荐回答（1个）

回答（1）：

if (filGzdr.FileName == "") { lblMsg.Text = "请选择要上传的文件"; return; } string ext = Path.GetExtension(filGzdr.FileName); if (ext != ".xls") { lblMsg.Text = "上传文件必须是.xls的格式"; return; } //string filename = DateTime.Now.ToShortDateString().Replace("-", "") + DateTime.Now.Millisecond.ToString() + ext; filGzdr.SaveAs(Server.MapPath("") + @"\payFile\" + filGzdr.FileName); string Image = Server.MapPath("") + @"\payFile\" + filGzdr.FileName; string strname = filGzdr.FileName; string[] str = filGzdr.FileName.Split('.'); zsDr.Open("insert into pay(FNO,FNAME,FCODE,FBUMEN,FCLASS,jcgz,zwgz,jbgz,glgz,lbt,jbt,gajc,jxjt,gzjt,shjt,dzf,yltf,gstf,bfje,cs,gwjt,shbt,yfgz,hk,fz,sf,df,qjlj,gjj,sfjs,ylbx,sfje) select FNO as FNO,FNAME as FNAME,FCODE as FCODE,FBUMEN as FBUMEN,FCLASS as FCLASS,F01 as jcgz,F02 as zwgz,F03 as jbgz ,F04 as glgz ,F05 as lbt ,F06 as jbt,F07 as gajc ,F08 as jxjt,F09 as gzjt,F10 as shjt,F11 as dzf,F13 AS YLTF,F14 as gstf,F15 as bFJE, F16 AS CS,F21 AS GWJT,F22 AS SHBT,F27 AS YFGZ,F28 HK,F31 AS FZ,F32 AS SF,F33 AS DF,F35 AS QJLJ,F36 AS GJJ,F40 AS SFJS,F42 AS YLBX,F45 AS SFJE from openrowset( 'Microsoft.Jet.OLEDB.4.0', 'EXCEL 5.0;HDR=YES;DATABASE=" + Image + "', [" + str[0] + "$])"); zsDr.Close(); File.Delete(Server.MapPath("") + @"\payFile\" + filGzdr.FileName); lblMsg.Text = "导入成功"; 上面那个判断是获得盘符

麻烦采纳，谢谢!

最新问答

家具能运到加拿大去吗供应，家具能运到加拿大去吗商机

微信怎么复制图片

申请瓦努阿图绿卡多久拿到卡？

北极地区的暖季在几月份到次年的几月份?