Used range and SQL query
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 !
|