Import excel sheet

Question

How to do i import excel sheet data into my database using only c# application?

Jacke Elis · Answer

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 .