Unable to read numeric values from Excel file using CDaoRecordset

[AnitaEugene]

Hi
I am using CDaoRecordset and GetFieldValue to read field values from an excel file.
But, I am not able to read the numeric fields. I only get VT_NULL when I try to read the numeric field.
If I manually change the field to text, I am able to read.

Now...
How do I read the numeric field using GetFieldValue or using any other method?
Thanks
Eugene