当前位置: 代码迷 >> ASP.NET >> 把EXCEL里的数据导入到SQLSERVER数据库老掉牙出错啊代码贴出来了
  详细解决方案

把EXCEL里的数据导入到SQLSERVER数据库老掉牙出错啊代码贴出来了

热度:413   发布时间:2013-02-25 00:00:00.0
把EXCEL里的数据导入到SQLSERVER数据库老出错啊,代码贴出来了
string StrCon;
  StrCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source" + Server.MapPath("ExcelFile/20120714164403943.xls") + ";Extended Properties= 'Excel 8.0;HDR=YES;IMEX=1';";
  OleDbConnection conn = new OleDbConnection(StrCon);
  OleDbDataAdapter myda = new OleDbDataAdapter("select * from[Data$]", StrCon);
  DataSet myds = new DataSet();
  myda.Fill(myds);
  GVRepairReport.DataSource = myds;
  GVRepairReport.DataBind();
老是找不到可安装的ISAM
各位大姐姐大哥哥们帮帮忙

------解决方案--------------------------------------------------------
文件路径正确吗?
StrCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + Server.MapPath("~/ExcelFile/20120714164403943.xls") + "';Extended Properties= 'Excel 8.0;HDR=YES;IMEX=1';";

Data Seource缺少=
------解决方案--------------------------------------------------------
粘贴个我现在用的给你看下
string mingchen = filename;
string filePath = Server.MapPath("~/UploadFile/" + wenjia + "/")+filename;//路径 

string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1'";
OleDbConnection ExcelConn = new OleDbConnection(strCon);
try
{
string strCom = string.Format("SELECT * FROM [Sheet1$]");
ExcelConn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, ExcelConn);
DataSet ds = new DataSet();
myCommand.Fill(ds, "[Sheet1$]");
ExcelConn.Close();
return ds;
}
catch (Exception ex)
{
ExcelConn.Close();
return null;
}
  相关解决方案