Check out our other answers here https://youtube.com/playlist?list=PLNIs-AWhQzcluqE43JKakRKslaYwCouJu

Get files here https://www.wiseowl.co.uk/vba-macros/videos/vba-ado-net-recordsets/recordset-to-array/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching!

This video explains how to use the GetRows method of an ADODB recordset to write data into an array.

Chapters
00:00 The Question
02:02 The GetRows Method
03:30 Limiting the Rows Returned
04:31 Specifiying the Columns Returned
05:59 Specifying Column Names in the Select Statement
07:04 Selecting the Top 10 Rows
07:33 Moving Back to the First Record

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more