How to Import Multiple Excel to Datagridview with Checklistbox path

Hello Gowtham Cp 
Thanks for all the solutions.

Hi Gowtham Cp
Thank you for reply
it's work and so great , 
Then I have a problem with the cell type of each file
I am looking for a solution

Hi Paradorn ,

You need to merge the data from all the Excel files instead of overwriting it each time. Right now, you're re-initializing the DataTable (dtable) in every loop, which is why only the data from the last file is displayed. The solution is to initialize the DataTable outside the loop and use the Merge() method to add rows from each file into the same DataTable. Here’s the code:

DataTable dtable = new DataTable(); // Initialize outside the loop

foreach (var item in checkedListBox1.CheckedItems)
{
    string constr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + item.ToString() + "';" +
                    "Extended Properties=\"Excel 8.0;HDR=YES;\"";
    string sheetname = "[MySheet$]";
    using (OleDbConnection conOle = new OleDbConnection(constr))
    {
        using (OleDbCommand comOle = new OleDbCommand("SELECT * FROM " + sheetname, conOle))
        {
            conOle.Open();
            using (OleDbDataAdapter datpOle = new OleDbDataAdapter(comOle))
            {
                DataTable tempTable = new DataTable(); // Temporary table for each Excel file
                datpOle.Fill(tempTable);
                dtable.Merge(tempTable); // Merge the temp table into the main DataTable
            }
        }
    }
}

dataGridView2.DataSource = dtable; // Bind the merged data to DataGridView

This way, all selected Excel files will be merged into one DataTable, and the DataGridView will display the combined data.

Hope it helps!