Import excel sheet

Hi Mane, this is one of the simplest ways that I can think of:

DataTable table = ExcelFile.Load("Sample.xlsx")
                            .Worksheets
                            .ActiveWorksheet
                            .CreateDataTable(
                                new CreateDataTableOptions());
 
using (var conn = new SqlConnection("Sample connection ..."))
{
    conn.Open();
    using (var bulkCopy = new SqlBulkCopy(conn))
        bulkCopy.WriteToServer(table);
}

The API is from this excel library for .NET.
You can use that first Load method to read both XLS and XLSX files in .NET.