public void ImportAllRows()
{
var ddlManager = new DDLManager();
var bulkdInsertManager = new BulkInsertManager();
String connString = GetConnectionString();
Console.WriteLine("Start time" + DateTime.Now);
ExcelStreamReader.Execute(fileName, reader =>
reader.ForEachSheet(sheet =>
{
var schema = sheet.GetSchema();
ddlManager.CreateTable(schema.TableName, schema, connString);
bulkdInsertManager.BulkInsertTo(schema, schema.TableName, sheet, connString);
})
);
Console.WriteLine("End time" + DateTime.Now);
}
public void ImportAllRows()
{
var ddlManager = new DDLManager();
var bulkdInsertManager = new BulkInsertManager();
String connString = GetConnectionString();
Console.WriteLine("Start time" + DateTime.Now);
ExcelStreamReader.Execute(fileName, reader =>
reader.ForEachSheet(sheet =>
{
var schema = sheet.GetSchema();
ddlManager.CreateTable(schema.TableName, schema, connString);
bulkdInsertManager.BulkInsertTo(schema, schema.TableName, sheet, connString);
})
);
Console.WriteLine("End time" + DateTime.Now);
}
static void Main(string[] args)
{
string fileName = @"C:\Users\pehe\Downloads\REPORT 73.xlsx";
var ddlManager = new DDLManager();
var bulkdInsertManager = new BulkInsertManager();
String connString = GetConnectionString();
Console.WriteLine("Start time" + DateTime.Now);
ExcelStreamReader.Execute(fileName, reader =>
reader.ForEachSheet(sheet =>
{
var schema = sheet.GetSchema();
ddlManager.CreateTable(schema.TableName, schema, connString);
bulkdInsertManager.BulkInsertTo(schema, schema.TableName, sheet, connString);
})
);
Console.WriteLine("End time" + DateTime.Now);
}