How to read an Excel field using ADO recordset?

I am try to read a field from an Excel file using ADO recordset. I can read the field alright, but I get a problem when I attemp to read a field that contains string in a column of data type number. For example, if I try to read from the data below, I will get a value of Null for cel C3. Is there a way that I can read the cell C3 and get 100k for the value? I been try to read just the text value as I see it on the worksheet.


A B C D

1 C2 C 90 2
2 C3 C 80 3
3 R1 R 100k 6



Please write back and let me know if you have any solution of not. Thank you so much.

Lynn =)