长编号那一栏,50Z70406-2   这个就显示不了 
代码如下: 
  string   strConn   =   "Provider=Microsoft.Jet.OLEDB.4.0;"   + 
                                                "Extended   Properties=\"Excel   8.0;HDR=Yes\";"   + 
                                                "data   source="   +   strPath; 
                System.Data.OleDb.OleDbConnection   Conn   =   new   System.Data.OleDb.OleDbConnection(strConn); 
                Conn.Open(); 
                string   strSql   =   "select   *   from   ["   +   strTable   +   "]"; 
                System.Data.OleDb.OleDbDataAdapter   myCommand   =   new   System.Data.OleDb.OleDbDataAdapter(strSql,   strConn); 
                DataSet   ds   =   new   DataSet(); 
                myCommand.Fill(ds,   "table1"); 
                Conn.Close(); 
                return   ds; 
网上看了一下,有人说加上     IMEX=1   ,我试过还是没用

解决方案 »

  1.   

        string       strConn       =       "Provider=Microsoft.Jet.OLEDB.4.0;"       +   
                                                                                                    "Extended       Properties=\"Excel       8.0;HDR=Yes;IMEx=1\";"       +   
                                                                                                    "data       source="       +       strPath;