Inserting Data in MDB from Excel Sheet

string connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + gstrFoldername + "\\" + gstrFileName + @".xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=2""";
            OleDbConnection conn = new OleDbConnection(connString);
            conn.Open();
            string query1 = "Select * from [Sheet1$]";
            OleDbCommand cmd = new OleDbCommand(query1, conn);
            OleDbDataReader dr = cmd.ExecuteReader();
            

            //Inserting into Access

              string conString = @"Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=" + gstrFoldername + "\\" + gstrFileName + ".mdb;"; 
            OleDbConnection con = new OleDbConnection(conString);
            con.Open();
            if (dr.HasRows) 
            {
                while (dr.Read())
                {
                    string[] strValue = new string[39];
                    for (int i = 0; i < dr.FieldCount; i++)
                    {
                        if (Convert.ToString(dr[i]).Contains("'"))
                        {
                          strValue[i]=  Convert.ToString(dr[i]);
                          strValue[i] = strValue[i].ToString().Replace("\'", "");
                        }
                        else
                        {
                           strValue[i] = Convert.ToString(dr[i]);
                        }
                    }
                    string query = "Insert into tbData values('" + Convert.ToString( strValue[0]) + "','" + Convert.ToString( strValue[1]) + "','" + Convert.ToString( strValue[2]) + "','" + Convert.ToString( strValue[3]) + "','" + Convert.ToString( strValue[4]) + "','" + Convert.ToString( strValue[5]) + "','" + Convert.ToString( strValue[6]) + "','" + Convert.ToString( strValue[7]) + "','" + Convert.ToString( strValue[8]) + "','" + Convert.ToString( strValue[9]) + "','" + Convert.ToString( strValue[10]) + "','" + Convert.ToString( strValue[11]) + "','" + Convert.ToString( strValue[12]) + "','" + Convert.ToString( strValue[13]) + "','" + Convert.ToString( strValue[14]) + "','" + Convert.ToString( strValue[15]) + "','" + Convert.ToString( strValue[16]) + "','" + Convert.ToString( strValue[17]) + "','" + Convert.ToString( strValue[18]) + "','" + Convert.ToString( strValue[19]) + "','" + Convert.ToString( strValue[20]) + "','" + Convert.ToString( strValue[21]) + "','" + Convert.ToString( strValue[22]) + "','" + Convert.ToString( strValue[23]) + "','" + Convert.ToString( strValue[24]) + "','" + Convert.ToString( strValue[25]) + "','" + Convert.ToString( strValue[26]) + "','" + Convert.ToString( strValue[27]) + "','" + Convert.ToString( strValue[28]) + "','" + Convert.ToString( strValue[29]) + "','" + Convert.ToString( strValue[30]) + "','" + Convert.ToString( strValue[31]) + "','" + Convert.ToString( strValue[32]) + "','" + Convert.ToString( strValue[33]) + "','" + Convert.ToString( strValue[34]) + "','" + Convert.ToString( strValue[35]) + "','" + Convert.ToString( strValue[36]) + "','" + Convert.ToString( strValue[37]) + "','" + Convert.ToString( strValue[38]) + "')";
                    OleDbCommand cmd1 = new OleDbCommand(query, con);
                    cmd1.ExecuteNonQuery();
                }
            }
            dr.Close();
            conn.Close();
            con.Close();




Example for how Inserting Data in MDB from Excel Sheet

Regards
Anil Pandey