Exemplo n.º 1
0
        public void ImportDataFromExcel(string excelFilePath)
        {
            DataTable table    = ConvertExcelToDataTable(excelFilePath);
            string    fileName = (Path.GetFileNameWithoutExtension(excelFilePath)).Replace(" ", "");

            table.TableName = fileName;

            if (!dbAccess.TableExists(fileName))
            {
                dbAccess.CreateDatabaseTable(table);
                dbAccess.FillTable(table);
            }
        }