Asp.net ¶ÁÈ¡EXCEL2007/2003 Êý¾Ý

Public DataTable GetDataTablefromExcel(string fileName,string tableName )
{
string connStr = "Provider=Microsoft.ACE.OLEDB.12.0; Persist Security Info=False;Extended Properties=Excel 8.0; data source=Îļþ·¾¶" 
string sql = "SELECT * from [" + tableName + "]";
OleDbConnection conn = new OleDbConnection(connStr);
try
{
   conn.Open();
   DataSet ds = new DataSet();
   OleDbDataAdapter da = new OleDbDataAdapter(sql, connStr);
   da.Fill(ds);
}
catch (Exception)
{
     throw;
}
finally
{
    conn.Close();
}
}
 
Microsoft.ACE.OLEDB.12.0:odbcÇý¶¯³ÌÐò¿ÉÒÔ¶ÁÈ¡*.xls,*.xlsx,*.xlsm,*.xlsb¸ñʽµÄÎļþ¡£