Download files here
By Andrew Gould
– In this video you’ll learn how to open an SQL Query file, read its contents and use the result to populate an ADO recordset. You’ll learn how to use file picker and folder picker dialog boxes to allow the user to pick which queries to run. You’ll also learn a little about the Scripting Runtime object library and how to work with FileSystemObjects and TextStreams.
If you’d like to help fund Wise Owl’s conversion of tea and biscuits into quality training videos, you can click this link to make a donation. Thanks for watching!
You can buy our Introduction to Excel VBA book here
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
Xem thêm bài viết khác: https://12m-15m.org/category/cong-nghe