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
Nguồn: https://12m-15m.org/
Xem thêm bài viết khác: https://12m-15m.org/category/cong-nghe
Thank you! Great stuff!
By the way, does anyone know how we can have the header?
Amazing!!! Thank you so much!!!
Just had a question, I am getting a Run-time error "3704": Operation is not allowed when the object is closed. error when I try close the rs variable during the test at timestamp 18:09. I have tried setting the cursor to client side, checking if rs.EOF and I just cannot figure out why vb thinks th result set is already closed. do you have any insight?
Thank you Andrew Sir as always
Hi Andrew ..need your urgent help..actually I have a database file with .pc extension.. I need to extract the information/tables from this file into excel / ms access…any link or suggestions plssss
Very beneficial
Yes it is very useful and all your videos and series are very wonderful. Best and Kind Regards my tutor
👍👍👍 Awesome
One quick question Andrew, are you using office 365 or office 2016?
3rd comment. As always amazing & awesome videos and teaching. Big thanks to Andrew.
Thank you, Andrew! It's wonderful and very useful!