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'>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 https://www.lulu.com/shop/andrewgoul...
By Andrew Gould
https://www.wiseowl.co.uk Connecting to databases in VBA sounds like it should be complicated, but using the ActiveX Data Objects, or ADO, Object Library makes life an awful lot easier! This video teaches you how to reference the library and how to create a connection to almost any type of database by providing the correct connection string (this video covers Microsoft Access and Microsoft SQL Server). We'll also show you how to grab a set of data from a database using recordset objects and even how to write SQL queries in your VBA procedures. The final part of the video talks about how you can take user input to modify the query to allow you to create a simply querying tool in VBA.
You can download the Access Movies database here:
https://www.wiseowl.co.uk/files/execi...
You can download the script to create the SQL Server Movies database used in this video at the following link:
https://www.wiseowl.co.uk/files/execi...
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!