）;
试试
{
//创建我们的连接字符串
string sexcelconnectionstring = @Provider = Microsoft.ACE.OLEDB.12.0; Data Source =+ excelfilepath +; Extended Properties =+\excel 12.0; hdr = yes ; \;

字符串sclearsql =TRUNCATE TABLE+ ssqltable;
SqlConnection sqlconn = new SqlConnection（strConnString）;
SqlCommand sqlcmd = new SqlCommand（sclearsql，sqlconn ）;
sqlconn.Open（）;
sqlcmd.ExecuteNonQuery（）;

//将数据从excel文件批量复制到我们的sql表中的一系列命令
OleDbConnection oledbconn = new OleDbConnection（sexcelconnectionstring）;
OleDbCommand oledbcmd = new OleDbCommand（myexceldataquery，oledbconn）;
oledbconn.Open（）;
OleDbDataReader dr = oledbcmd.ExecuteReader（）;




SqlBulkCopy bulkcopy = new SqlBulkCopy（strConnString）;
bulkcopy.DestinationTableName = ssqltable;
//映射表列

bulkcopy.ColumnMappings.Add（任务，[任务]）;
bulkcopy.ColumnMappings.Add（Caption，[Caption]）;
bulkcopy.ColumnMappings.Add（开始日期，[Start_Date]）;



{
bulkcopy.WriteToServer（dr）;

}
oledbconn.Close（）;
sqlconn.Close（）;

)"; try { //create our connection strings string sexcelconnectionstring = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + excelfilepath + ";Extended Properties=" + "\"excel 12.0;hdr=yes;\""; string sclearsql = "TRUNCATE TABLE " + ssqltable; SqlConnection sqlconn = new SqlConnection(strConnString); SqlCommand sqlcmd = new SqlCommand(sclearsql, sqlconn); sqlconn.Open(); sqlcmd.ExecuteNonQuery(); //series of commands to bulk copy data from the excel file into our sql table OleDbConnection oledbconn = new OleDbConnection(sexcelconnectionstring); OleDbCommand oledbcmd = new OleDbCommand(myexceldataquery, oledbconn); oledbconn.Open(); OleDbDataReader dr = oledbcmd.ExecuteReader(); SqlBulkCopy bulkcopy = new SqlBulkCopy(strConnString); bulkcopy.DestinationTableName = ssqltable; //Mapping Table column bulkcopy.ColumnMappings.Add("Task", "[Task]"); bulkcopy.ColumnMappings.Add("Caption", "[Caption]"); bulkcopy.ColumnMappings.Add("Start Date", "[Start_Date]"); { bulkcopy.WriteToServer(dr); } oledbconn.Close(); sqlconn.Close();

试试这个：

Try this:

string myexceldataquery = "Select * FROM [Details

A2：G];;

A2:G];";