Excelµ¼ÈëSqlserverÊý¾Ý¿âµÄÎÊÌâ

´úÂëÈçÏ£º
string myString = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =  " + savePath + fileName + ";Extended Properties=Excel 8.0"; 
OleDbConnection oconn = new OleDbConnection(myString); 
oconn.Open(); 
DataSet ds = new DataSet(); 
OleDbDataAdapter oda = new OleDbDataAdapter("select * from [Sheet1$]", oconn); 
oda.Fill(ds); 
oconn.Close();


ÎÊÌâ1£ºExcel±íÖÐÖ»ÓÐ1ÌõÊý¾Ý£¬µ¼ÈëSqlºóÓкܶàµÄ¿Õ°×ÐУ¬Ô­ÒòÊÇExcelµÎÎÊÌ⣬Ӧ¸ÃÊÇÔø¾­Ð´¹ý 24 ÐÐÊý¾Ý£¬ºóÀ´É¾³ýÁË 22 ÐУ¬¶øExcel»á×Ô¶¯¼Ç¼×îºóÊý¾ÝÐеÄλÖã¨ÀàËÆÒ»¸öµ¥ÏòÖ¸Õ룩£¬Ôõô¹ýÂËÕâЩ¿Õ°×ÐÐ
select * from [Sheet1$] where [A] <> '' ÕâÑùµÄд·¨ºÃÏñ²»¶Ô£¨AΪExcelÁÐÃû£©£¬ÕýÈ·µÄд·¨Ó¦¸ÃÔõÑùд£¿

ÎÊÌâ2£ºÔõô·ÀÖ¹Öظ´µ¼ÈëµÄÊý¾Ý£¿

---

×Ô¼º×øɳ·¢£¬Â·¹ýµÄ´óϺÃÇ°ïæ¿´¿´°¡

---

ÔÚÏßµÈÈ˻شð

---

string strConn = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" + filenameurl + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'";

OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
DataSet ds = new DataSet();
OleDbDataAdapter odda = new OleDbDataAdapter("select * from [" + sheet + "]", conn);
odda.Fill(ds);
return ds;

Äã¿´¿´ÓÐɶ²»Í¬£¬ÒÔÇ°×ö¹ý£¬£¬£¬

---

1¡¢Òª²»¼ì²éÏ Excel ¸ñʽ£¬°ÑExcel±