如何将Excel表格中的数据导入到SQL库
private DataSet GetOleData(){
OleDbConnection objConn = null;
DataSet ds = new DataSet();
string FileAddr = "D: \\test.xlsx";
string strConn = " Provider=Microsoft.ACE.OLEDB.12.0;Data Source='"FileUpload1.PostedFile.FileName.ToString() + "';Extended Properties='Excel 12.0;HDR=Yes;IMEX=1' ";
objConn = new OleDbConnection(strConn);
objConn.Open();
string strSql = "select * from [Sheet1$] ";
OleDbCommand objCmd = new OleDbCommand(strSql, objConn);
OleDbDataAdapter sqlada = new OleDbDataAdapter();
sqlada.SelectCommand = objCmd;
sqlada.Fill(ds, "MyRecords ");
objConn.Close();
return ds;
DataRow[] dr = ds.Tables[0].Select(); //定义一个DataRow数组
int rowsnum = ds.Tables[0].Rows.Count;
if (rowsnum == 0)
{
Response.Write("<script>alert('Excel表为空表,无数据!')</script>"); //当Excel表为空时,对用户进行提示
}
else
{
for (int i = 0; i < dr.Length; i++)
{
string pininputdate = dr[i]["excel列名"].ToString();//日期 excel列名【名称不能变,否则就会出错】
// string insertstr = "insert语句";
OleDbCommand cmd = new OleDbCommand(strSql, objConn);
怎么加语句是这部分程序顺利运行????? --------------------编程问答-------------------- 你的数据都已经取出来了,为什么还写不进去呢? --------------------编程问答-------------------- 数据取出来还不好插啊,
直接往数据库中用insert插入就可以了 --------------------编程问答--------------------
insert into #tempTable select * from [Sheet1$]
delete from #tempTable where 数据为空
insert into yourTable select * from #tempTable
好像不用那么麻烦吧 --------------------编程问答--------------------
够直接
补充:.NET技术 , C#