MS Access Records
Hi
The following can extract data from one row in an Access table;
(Connection and Recordset declared)
ThisWorkbook.Sheets(3).Cells(h, i).Value = rs.Fields(i).Value
But does Access has something similar to Cells(h,i) to enable extracting
data of a whole table using a 'For Loop'.
Can someone help?
Thanks.
|