ADO recordset can not read the field from Excel file

L

Louis

In my home computer(win xp): rst.Fields(keyCol)=null when the field is a
string;
in my office computer(win 2000): rst.Fields(keyCol)=null when the field is a
number; if I use the following way to retrive the info from Excel file.
Please advise. Thank you.

conn.Open "Provider=Microsoft.jet.OLEDB.4.0;" & _
"Data Source=" & myExcelFile & ";" & _
"Extended Properties=Excel 8.0;"
rst.Open "myRange", conn, , , adCmdTable
msgbox rst.Fields(keyCol)
 
Top