62,046
社区成员
发帖
与我相关
我的任务
分享
tempname = Server.MapPath("./ATTExcel");
tempname = tempname + Convert.ToString(DateTime.Now.Year) + Convert.ToString(DateTime.Now.Month) + Convert.ToString(DateTime.Now.Day) + Convert.ToString(DateTime.Now.Hour) + Convert.ToString(DateTime.Now.Minute) + Convert.ToString(DateTime.Now.Second) + ".xls";
FileUpload1.SaveAs(tempname);
sPath = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";
OleDbDataAdapter adp = new OleDbDataAdapter("Select * from [Sheet1$]", sPath);
adp.Fill(ds, "Book1");
adp.Dispose();