Excel VBA Introduction Part 56.2 - Get Data from SQL Server with ADO Recordsets

Download the files here https://www.wiseowl.co.uk/vba-macros/... By Andrew Gould https://www.wiseowl.co.uk - This video shows you how to extract data from a SQL Server database using the ActiveX Data Objects (ADO) library for VBA and the Microsoft OLE DB Driver for SQL Server. You'll learn how to write a connection string to connect to a SQL Server databse and how to use a recordset to retrieve data. You'll learn how to populate the recordset using SQL Server tables, views, stored procedures and select statements and how to write the data you've retrieved into an Excel Worksheet. 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! You can buy our Introduction to Excel VBA book here http://www.lulu.com/shop/andrew-gould... Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, VBA, Power BI, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more