C#连接Excel读取与写入数据库SQL （ 上 ）

        public bool GetFiles(string equipName)         {             //choose all sheet?  or all data in sheet?             string strExcel = "select * from [Sheet1$]";             //初始化system.IO的配置（路径)             DirectoryInfo directoryInfo1 = new DirectoryInfo(WPath + equipName + "\Working");             //用文件流来获取文件夹中所有文件，存放到             FileInfo[] files1 = directoryInfo1.GetFiles();             foreach (FileInfo file in files1) // Directory.GetFiles(srcFolder)             {                 // 连接到excel 数据源,   xlsx要用ACE                 string strConn = ("Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source= " + file.FullName + "; Extended Properties='Excel 12.0';");                 OleDbConnection OledbConn = new OleDbConnection(strConn);                 if (IsUsed(file.FullName))                 {                     flag = IsUsed(file.FullName);                      continue;                 }                 try                 {                     OledbConn.Open();                     // 存入datatable                     OleDbDataAdapter dAdapter = new OleDbDataAdapter(strExcel, strConn);
　　　　　　　　　　　　//写入ds中的一个table                     dAdapter.Fill(ds);                     OledbConn.Dispose();                     OledbConn.Close();                 }                 catch (Exception ex)                 {                  }             }         }