excel中导入到sql2005的表中

Question

如果在客户端设置一个浏览控件 允许用户直接浏览本地机器的excel表格 然后上传。excel中的表头内容和数据库中表的内容相同，能否直接实现将excel中的内容直接导入到数据库中对应的表中。如何实现asp.net(C#)。谢谢各位帮忙，需要代码。

Answer 1

http://dev.csdn.net/article/72/72658.shtm这些东西从网上直接就能够查找到

Answer 2

fileName = Request.MapPath(filePath);
                    // string    strConn ="Provider=Microsoft.Jet.Oledb.4.0;Data Source=" + Dir + "\\"+fileName + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1;\"
                    string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";
                    string query = "SELECT   *   FROM   [Sheet1$]";
                    OleDbCommand oleCommand = new OleDbCommand(query, new OleDbConnection(strConn));
                    OleDbDataAdapter oleAdapter = new OleDbDataAdapter(oleCommand);
                    DataSet myDataSet = new DataSet();                    //   将   Excel   的[Sheet1]表内容填充到   DataSet   对象 
                    try
                    {
                        oleAdapter.Fill(myDataSet, "[Sheet1$]");
                        //   数据绑定 
                        this.dgExportProject.DataSource = myDataSet;
                        this.dgExportProject.DataMember = "[Sheet1$]";
                        this.dgExportProject.DataBind();                        this.dgExportProject.Visible = true;
                        this.btnSave.Visible = true;
                    }
                    catch (Exception exx)
                    {
                        Response.Write(exx.Message);
                        //Comm.Jscript.Alert("注意：请用默认的Sheet1$页名称！"); 
                    }
                    finally
                    {
                        if (File.Exists(filePath))
                        {
                            File.Delete(filePath);
                        }
                    }