string strConn;
string FileName = "测评题库.xls";
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= c:\\Inetpub\\wwwroot\\HRManage\\UpLoadFile\\" + FileName + ";Extended properties=Excel 5.0";
string sList = "c"; //表名;
OleDbConnection oConn = new OleDbConnection();
oConn.ConnectionString = strConn;
oConn.Open(); OleDbDataAdapter oCmd = new OleDbDataAdapter("SELECT * FROM [" + sList + "$]", oConn);
DataSet oDS = new DataSet();
oCmd.Fill(oDS); foreach (DataRow oRow in oDS.Tables[0].Rows)
{
//插入Theme表;
QContent = oRow["题目内容"].ToString();
QAnswer = oRow["答案"].ToString(); //这两列总能读出.都包含有汉字;
QContent1 = oRow["选项C"].ToString();
QContent2 = oRow["选项D"].ToString();//这两列当值全为数字时为空,如果有汉字或者英文,也能读出.
}
没读出时oRow["选项D"].ToString()的值为"" 救命!!
string FileName = "测评题库.xls";
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= c:\\Inetpub\\wwwroot\\HRManage\\UpLoadFile\\" + FileName + ";Extended properties=Excel 5.0";
string sList = "c"; //表名;
OleDbConnection oConn = new OleDbConnection();
oConn.ConnectionString = strConn;
oConn.Open(); OleDbDataAdapter oCmd = new OleDbDataAdapter("SELECT * FROM [" + sList + "$]", oConn);
DataSet oDS = new DataSet();
oCmd.Fill(oDS); foreach (DataRow oRow in oDS.Tables[0].Rows)
{
//插入Theme表;
QContent = oRow["题目内容"].ToString();
QAnswer = oRow["答案"].ToString(); //这两列总能读出.都包含有汉字;
QContent1 = oRow["选项C"].ToString();
QContent2 = oRow["选项D"].ToString();//这两列当值全为数字时为空,如果有汉字或者英文,也能读出.
}
没读出时oRow["选项D"].ToString()的值为"" 救命!!
--从Excel文件中,导入数据到SQL数据库中,很简单,直接用下面的语句:
/*===================================================================*/
--如果接受数据导入的表已经存在
insert into 表 select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;DATABASE=c:\test.xls',sheet1$)--如果导入数据并生成表
select * into 表 from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Excel 5.0;HDR=YES;DATABASE=c:\test.xls',sheet1$)
OpenDataSource('MICROSOFT.JET.OLEDB.4.0', 'Excel 8.0; HDR=1; IMEX=1; DATABASE=c:\test.xls')...[input$]
然后再重新拷贝回去保存,试试。