How to Convert Excel Data to a Table in SQL Server 2005

TotalSheets = MyWorkbook.Worksheets.Count;
foreach (Excel.Worksheet wksh in MyWorkbook.Worksheets)
{
AllSheets.Items.Add(wksh.Name);
}
MyWorkbook.Close(false, false, false);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}

}
Note: Because you are using the Excel properties, first add the reference for Excel.

4. When you will click on the Browse button it will ask for filename. Select the file and then whatever the sheets in that workbook will be displayed in ComboBox. Select any sheet and click on save.

Public void Save_Click()
{
OleDbConnection con = null;
OleDbCommand com = null;
OleDbDataAdapter da = null;
DataSet ds = null;
string SheetName;

SheetName = comboBox1.SelectedItem.ToString();

string constr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ExcelFile + ";Extended Properties=Excel 8.0";
con = new OleDbConnection(constr);
con.Open();
string strr = "select * from [" + SheetName + "$]";
com = new OleDbCommand(strr, con);
da = new OleDbDataAdapter();
da.SelectCommand = com;
ds = new DataSet();
da.Fill(ds);
TotalCols = ds.Tables[0].Columns.Count;
TotalRows = ds.Tables[0].Rows.Count;

string query=null;
try
{
SqlConnection con = new SqlConnection("Data Source=MyDataServer;Database=CustomerData;Integrated
Security=true");
con.Open();
SqlCommand com = new SqlCommand();
com.Connection = con;
query = "create table Customer(" + ds.Tables[0].Columns[0].ToString().Replace(" ","_") + " varchar(200)";
int i;
for (i = 1; i < TotalCols; i++)
{
string ActualField = ds.Tables[0].Columns[i].ToString();
string FinalField = ActualField.Replace(" ", "_");
query += "," + FinalField + " varchar(200)";
}
query += ")";
com.CommandText = query;
com.ExecuteNonQuery();
int ins, co;
query = "";
for (ins = 0; ins < TotalRows; ins++)
{
query = "insert into Customer values('" + ds.Tables[0].Rows[ins][0];
for (co = 1; co < TotalCols; co++)
{
query += "','"+ds.Tables[0].Rows[ins][co].ToString();
}
query += "')";
com.CommandText = query;
com.ExecuteNonQuery();
}
MessageBox.Show("Record saved");
}
catch (Exception ex)
{
MessageBox.Show("error: "+query+ "--"+ex.Message);
}
}