/// <summary> /// import from sheet Pojistovna /// </summary> /// <param name="excel_con"></param> private void ImportPojistovna(OleDbConnection excel_con) { DataTable dtExcelData = new DataTable(); dtExcelData.Columns.AddRange(new DataColumn[3] { new DataColumn("Id", typeof(int)), new DataColumn("Nazev", typeof(string)), new DataColumn("Zkratka", typeof(string)) }); using (OleDbDataAdapter oda = new OleDbDataAdapter("SELECT * FROM [Pojistovna$]", excel_con)) { oda.Fill(dtExcelData); foreach (DataRow row in dtExcelData.Rows) { _dataConnector.CreatePojistovna((string)row["Nazev"], (string)row["Zkratka"]); } } }