How to import data from an excel file

you can try using this code. here a function write in C#. you put excel file name and sheet name then function return a datatable according your excel file data. also you can use this datatable any your purpose.

Code Here:

public DataTable GetExcelSheetData(string excelFileName, string excelSheetNames)
    {
        OleDbConnection con = null;
        DataTable dt = new DataTable();
        String conStr = "Provider=Microsoft.Jet.OLEDB.4.0;" +
            "Data Source=" + excelFileName + ";Extended Properties=Excel 8.0;";
        con = new OleDbConnection(conStr);
        con.Open();
        OleDbCommand cmd = new OleDbCommand("select * from [" + excelSheetNames + "]", con);
        OleDbDataAdapter oleAdapter = new OleDbDataAdapter();
        oleAdapter.SelectCommand = cmd;
        oleAdapter.FillSchema(dt, SchemaType.Source);
        oleAdapter.Fill(dt);
        con.Close();
        return dt;
    }

A good starting point would be Ole connections. link below:
http://developers-heaven.net/forum/index.php/topic,45.0.html[^]

First, use google

http://lmgtfy.com/?q=read+excel+file+%20c%23[^]