Excel Load To DataTable using OleDb in C#

Note :This post is first published on Apr-2013 in my previous blog Techkindle. Moving the content to here.

Here we will try to load Excel sheet data into the datatable using Jet engine.
First, We need to Download and install the AccessDatabaseEngine exe from the microsoft website.

Complete Source Code


Happy Coding :)