It's one of the main hurdles any developer will face during development life cycle. We have Excel sheet or CSV sheet and client want to save data of Excel/CSV file to be saved in database with the help of C# coding. Here I'll explain how we can import Excel and CSV file and then create data-table of file records. We can then easily use this data-table to insert record in DB (here I'm not explaining how to insert record to DB). Here is function to import excel file and return DataTable : Namespace required are: System.Data and System.Data.OleDb ; private DataTable GetExcelSheetdata() { DataTable dt = new DataTable (); try { // Url of file to be imported. var url = @"c:\test.xls" ; // Create OleDB connection string. string connectionString = String .Format( @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0;"&qu