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，巨方便，功能也强大