hi

refer below thread

http://www.aspforums.net/Threads/163566/Export-DataTable-to-Excel-without-any-dll-using-C-and-VBNet-in-ASPNet/?s=2#Replies

I use below code to export data from database into excel:

 public void DataTableToExcel(DataTable dt)
    {
        HttpResponse response = HttpContext.Current.Response;
        response.Clear();
        response.ClearHeaders();
        response.ClearContent();
        response.Charset = Encoding.UTF8.WebName;
        response.AddHeader("content-disposition", "attachment; filename=" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls");
        response.AddHeader("Content-Type", "application/Excel");
        response.ContentType = "application/vnd.xlsx";
        using (StringWriter sw = new StringWriter())
        {
            using (HtmlTextWriter htw = new HtmlTextWriter(sw))
            {
                GridView gridView = new GridView();
                gridView.DataSource = dt;
                gridView.DataBind();
                gridView.RenderControl(htw);
                response.Write(sw.ToString());
                gridView.Dispose();
                dt.Dispose();
                response.End();
            }
        }
    }
    protected void Imgsave_Click(object sender, ImageClickEventArgs e)
    {
        using (SqlConnection conn = General.GetConnection())
        {
            using (SqlCommand _cmd = General.GetCommand("Estate_ViewInfoB", conn))
            {
                using (SqlDataAdapter sda = new SqlDataAdapter())
                {
                    _cmd.Connection = conn;
                    sda.SelectCommand = _cmd;
                    using (DataTable dt = new DataTable())
                    {
                        sda.Fill(dt);
                        DataTableToExcel(dt);
                    }

                }
            }
        }

    }

now I want import this excel file into database how I can do it?

Best regards

neda