how to transfer data from excel sheet to sql server in xml format?

Question

can i use sql server2005?
if yes which edition?

Answer 1

Use SSIS (SQL Server Integrated Services) to import the data from Excel into your SQL database.

Answer 2

hi, I provide you code that are stated under public void ExportToExcel(DataTable dt) { con.Open(); string sq. = "decide on *from try"; cmd = new SqlCommand(sq., con); dt = new DataTable(); da = new SqlDataAdapter(cmd); da.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); cmd.Dispose(); string filename = "DownloadTest.xls"; equipment.IO.StringWriter tw = new equipment.IO.StringWriter(); equipment.cyber web.UI.HtmlTextWriter hw = new equipment.cyber web.UI.HtmlTextWriter(tw); DataGrid dgGrid = new DataGrid(); dgGrid.DataSource = dt; dgGrid.DataBind(); dgGrid.RenderControl(hw); reaction.ContentType = "application/vnd.ms-excel"; reaction.AppendHeader("content textile-Dispositi... "attachment; filename=" + filename + ""); this.EnableViewState = fake; reaction.Write(tw.ToString()); reaction.end(); con.close(); }