Excel 表如何导入数据库？

Question

Excel表如何导入数据库（如SQL数据库或ACCESS数据）？求代码

Answer 1

public static DataSet ReadExcelFileToDataSet(String fileName, string sheetName)
        {
            FileInfo fileInfo = new FileInfo(fileName);
            String strConn;
            if (fileInfo.Extension.ToLower() == ".xlsx")
            {
                strConn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties='Excel 12.0 Xml;HDR=YES'";
            }
            else
            {
                throw new Exception("only .xlsx file can be read");
            }
            OleDbConnection Conn = new OleDbConnection(strConn);
            DataSet ds = new DataSet();
            try
            {
                string SQL = "select * from [" + sheetName + "$]";
                Conn.Open();
                OleDbDataAdapter da = new OleDbDataAdapter(SQL, strConn);
                da.Fill(ds);
                return ds;
            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }
            finally
            {
                Conn.Close();
                Conn.Dispose();
            }
        }

Answer 2

以上提供的方法都是可行的

还有另外一种操作excel2007的epplus

Answer 3

我也推荐NPOI，巨方便，功能也强大