By Andrew Gould

This video explains how to get around the 255 column limit when importing data using ADODB in Excel VBA.

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join

Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

Download files here https://www.wiseowl.co.uk/vba-macros/videos/vba-ado-net-recordsets/adodb-excel-255-columns/

Chapters
00:00 The Question
02:08 The Approach to Solving the Problem
03:05 Calculating the Number of Column Groups
09:09 Calculating Column Numbers in Each Group
13:33 Calculating the Column References
16:51 Selecting more than 255 Columns
18:31 Stopping at the Last Set of Columns
20:22 Adding a Basic Error Handler
22:36 Selecting a Single Specific Column

Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!