Hello !

The Jet engine allows to retrieve the contents of a range in a recordset, with
queries like :

SELECT * FROM [Sheet1$A1:B4]

Problem : suppose that in this sheet, only the cells A4:B4 are populated (all
other cells are empty).

In this case, the recordset built by the above query will have only 1 record,
containing the values of A4:B4, and not what we expect (A1:B4).

Is it possible to obtain the right records, ie :

Record 1 : Null - Null
Record 2 : Null - Null
Record 3 : Null - Null
Record 4 : Value of A4 - Value of B4


Thanks !