asp中把excel中數據導入SQL數據庫

{

OleDbConnection connread = new OleDbConnection("provider=microsoft.jet.oledb.4.0; data source=D:\\Book1.xls; extended properties=excel 8.0");

connread.Open();

OleDbDataAdapter da = new OleDbDataAdapter("select * from [Sheet1$]", connread);

DataSet ds = new DataSet();

da.Fill(ds);

connread.Close();

SqlConnection conn = new SqlConnection("server=.; integrated security=true; database=demo");

conn.Open();

SqlCommand cmd = new SqlCommand("create table name(name varchar(100),namea varchar(100),nameb varchar(100))", conn);

for (int i = 0; i < ds.Tables[0].Rows.Count; i++)

{

string p=string.Format("insert into name values('{0}','{1}','{2}')",ds.Tables[0].Rows[i]["name"].ToString().Trim(),ds.Tables[0].Rows[i]["namea"].ToString().Trim(),ds.Tables[0].Rows[i]["nameb"].ToString().Trim());

cmd = new System.Data.SqlClient.SqlCommand(p, conn);

cmd.ExecuteNonQuery();

}

conn.Close();

}