(急）求助：不打开excel文件读取里面的数据

Question

http://www.csdn.net/Develop/Read_Article.asp?Id=15544
http://www.csdn.net/Develop/Read_Article.asp?Id=16987

Answer 1

private DataSet CreateDataSource(){
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=C:\\Inetpub\\wwwroot\\contacts.xls;"+
"Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [ContactList$]", strConn);
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet);
return myDataSet;

Answer 2

http://www.yesky.com/20020313/1601534.shtml