Excel recordset returns Null value

[shahid09]

Hi All,

I have created recordset from excel but i have noticed one weird thing. Excell cell has some value Like"6L0" but it returns NULL.
Sometimes if cell is empty it return NULL which i am taking care using following code, but if cell has some value and it returns value how should i handle this situation ?
Here is how i handle that situation when cell is empty and returns NULL

If IsNull(objRecordSet(intCounter)) Then
     ActualArray(intRowCount, intCounter )= ""
Else
   ActualArray(intRowCount, intCounter ) = objRecordSet(intCounter)
End If

My question here is objRecordSet(intCounter) has some value in table but returns NULL how should i handle this situation ?

Thanks,
Shahid