public static void generate(string xlsxPath, string datatypePath = null) { string filename = Path.GetFileNameWithoutExtension(xlsxPath); filename = filename.Replace(" ", "_"); string pathWOExtension = Path.GetDirectoryName(xlsxPath)+ "\\" + filename; DatabaseInfo.DatabaseName = filename; //convert from xlsx to csv string csvPath = pathWOExtension + ".csv"; Console.WriteLine("csvPath is: " + csvPath); XLSXToCSVConverter.toCSV(xlsxPath, csvPath); //represent csv as an object CSVWrapper csv = new CSVWrapper(); csv.openCSV(csvPath); //make the contents of the sql script string sqlPath = pathWOExtension + ".sql"; Console.WriteLine("sqlPath is: " + sqlPath); string sqlContent = new SQLBuilder(csv, filename, filename+"Table", datatypePath). CreateDatabase().DropTable().CreateUse().CreateTable().CreateInsert().Build(); //make the contents of the connection string file string dbPath = pathWOExtension + ProjectStrings.CONNECTION_STRING_FILE_EXTENSION; string dbContent = DatabaseInfo.DatabaseName; //write sql to file System.IO.File.WriteAllText(sqlPath, sqlContent); System.IO.File.WriteAllText(dbPath, dbContent); string[] lines = sqlContent.Split('\n'); createDatabaseFromSql(lines, filename); populateDatabaseFromSql(lines, filename); }