C# Excel导入Access

  1 /// <summary>
  2 /// 导入
  3 /// </summary>
  4 private void btn_In_Click(object sender, EventArgs e)
  5 {
  6     int i = DataTableToDB();
  7     MessageBox.Show("成功导入" + i + "条商品信息！");
  8 }
  9 
 10 
 11 
 12 
 13 /// <summary>
 14 /// 获取后缀名为*.xlsx的文件
 15 /// </summary>
 16 public void GetFile()
 17 {
 18      System.IO.DirectoryInfo dir = new DirectoryInfo(VPath);
 19      if (dir.Exists)//判读是否存在改文件
 20      {
 21          fiList = dir.GetFiles("*.xlsx"); //获取后缀名为*.xlsx的文件
 22      }
 23 }
 24 
 25 
 26 /// <summary>
 27 /// Excel数据转化为DataTable
 28 /// </summary>
 29 /// <param name="strSheetName"></param>
 30 /// <param name="strExcelFileName">文件路径</param>
 31