ASP.NET: excel加两列导入到sqlserver
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+filename+";User );
conn.Open();
DataTable dt=conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new object[] {null,null,null,"TABLE"});
string eName="["+dt.Rows[0]["TABLE_NAME"].ToString ().Trim()+"]";
OleDbCommand cmd = new OleDbCommand("insert into [ODBC;Driver=SQL Server;U"+DL_Y.SelectedItem.Text+"' as [year],'"+DL_M.SelectedItem.Text+"' as [month] from "+eName,conn);