将 Excel 数据读取到数据集的问题——难！急！

[zcwmxn]

有一个程序在同事机器上正常，拿到我机器上就不成。
报：
异常详细信息: System.Data.OleDb.OleDbException: 未指定的错误
程序出错的部分为

Dim myDataset As New DataSet
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("/upload/") & "" & strFileNameOnly & ";" & _
"Extended Properties=Excel 8.0;"
''You must use the $ after the object you reference in the spreadsheet
Dim myData As New OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn)
myData.TableMappings.Add("Table", "ExcelTest")
myData.Fill(myDataset)

DataGrid1.DataSource = myDataset.Tables(0).DefaultView
DataGrid1.DataBind()


System.Data.OleDb.OleDbException是系统错误，是不是我的framework框架有问题了？很是不解，最不解的是成功过一次，确切的说是成功了一下午。


我的系统是 2000 pro 版 + excel 2000
同事的机器有
2000 server + excel 2000
xp pro + excel xp
2003 server + excel xp
xp + excel 2000
不知道是不是跟这些有关？

[bitsbird]

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
"HDR=Yes;" indicates that the first row contains columnnames, not data
"IMEX=1;" tells the driver to always read "intermixed" data columns as text
TIP! SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.

[zcwmxn]

无人解答？