Random cells appear as NULL when opening excel sheets as recordsets?!?!

[ale]

Aaaahhhh!!! I'm loosing it with this one.
I'm opening sheets as recordsets and some of the cells (with data in them) appear to have null values and some don't. The sheets are in Excel 4.0 format but I already tried converting them to Excel 97. I even used Access to import the sheets as linked tables and the same happened!! Some cells where transfered as "#Value!". When I trien importing (without linkning) this didn't happen (still in access)!!! Back to VB, I used to read the values via DDE but it was too slow (but the values where read correctly).
Do you hava any ideas? Is there another method? I guess I can do it with OLE but I don't know how to do it. Is it easy? Is this a bug in Excel? The problem presents in different cells in different sheets (but always in the same cells for a particular sheet). I have to finish this program and I'm stuck. Please, help!

[Jaguar]

I'm sorry I'm responding to your posting without a solution. But I think you're out of luck, unless someone else knows what's wrong. I've had the same problem, and I think it was how someone was saving something the the spreadsheet. They didn't touch the cell at all and it was IS NULL, but they touched the cell and erased whatever was there and it IS NOT NULL.

There was no consistency in finding why different cells worked differently. But it was a long those lines.

[ale]

Thanks anyway. I'll see if something comes out of what you told me.