Excel VBA Introduction Part 56.3 - Read and Execute SQL Query Files

[@radheymaurya3655]

No such as content available on KZbin better then Wise 🦉👍!!!!

[@WiseOwlTutorials]

Thanks Radhey!

[@FastingDude]

This has been so helpful for my job. From excel I moved to VB.net and C# to not only retrieve data, but also insert data from files or other databases. Thank you so much!

[@WiseOwlTutorials]

You're very welcome! I'm so pleased that the videos helped you with that and thank you for taking the time to leave a comment!

[@jalindar1000]

@wise owl you saved my life thank you ❣️

[@KhalilYasser]

Yes it is very useful and all your videos and series are very wonderful. Best and Kind Regards my tutor

[@WiseOwlTutorials]

Thank you Yasser, I appreciate the continued support and comments!

[@sashatv138]

Thank you, Andrew! It's wonderful and very useful!

[@WiseOwlTutorials]

You're very welcome Alexander! Thank you as always for watching and for your comments!

[@tejamarneni]

3rd comment. As always amazing & awesome videos and teaching. Big thanks to Andrew.

[@WiseOwlTutorials]

Thank you Ravi, I appreciate the comments and thanks for watching!

[@douglasd1986]

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?

[@douglasd1986]

So it seems all I needed was to add SET NOCOUNT ON at the top of my sql script and all works after that.

[@WiseOwlTutorials]

Thanks for posting the answer, Douglas. Sorry that I didn't see the question before you discovered the solution!

[@affection788]

Hi, Can you please tell me where did you add the SET NOCOUNT ON? I am also getting the same error and adding the SET NOCOUNT ON gives me syntax error

[@liortt12]

@@WiseOwlTutorials hello, i tried that, now working..

[@ta5fa]

wait 100 I want it to repeat the wait time randomly in a time interval how should my line of code be ?

[@turbo172001]

thank you very much for you and your team

[@WiseOwlTutorials]

Our pleasure! Thank you for watching and for taking the time to leave a comment!

[@hubsun]

Thank you..great topic and explained well.

[@WiseOwlTutorials]

Thank you Hubert!

[@pradeeprawatvlogs8358]

Thank you Andrew Sir as always

[@WiseOwlTutorials]

You're welcome, Pradeep, as always!

[@cormackeenan8175]

Public service announcement: Please note that in an SQL server that has many databases its usual to put “USE ?” The question mark represents the name of the database you want to do the query against. Eg: Use T10Bankstatements Select * From T10Bankstatements T10 Where T10.Amount > 10000 Order by T10.Date01; In this video if you use the “Use ?” Convention the code will give an file closed error. I know it was not used in this video but if one is used to writing sql query its almost a de facto convention. It took me an hours to track down the problem. Please note I haven’t checked if using an alias T10 causes a problem, but it really helps with field names.

[@noorsalh2822]

Helllo, Thanks for those videos really helpful. I have question here, if my query file is on computer and need to access it on excel file located on other computer how can i set the path in VBa code, any suggestion?

[@WiseOwlTutorials]

Hi Noor! You can just use the path you would use to access the file over your network, for example "\\serverName\sharedFolder\MyQuery.qry" I hope it helps!

[@FastingDude]

I do have a question, I am not sure if you have any videos connecting to Oracle databases. There is a TNS.ORA file that has a weird connection string, I tried searching online for a way to connect but I couldn't make it happen.

[@WiseOwlTutorials]

I'm afraid that I don't have any experience with Oracle but I always rely on ConnectionStrings.com. I'm sure that you will know this already but just in case you haven't seen it www.connectionstrings.com/oracle/ Other than that I'm not sure, sorry!

[@deeg3317]

Is there a way to pass a value from excel VBA to the a local variable in the SQL file?

[@WiseOwlTutorials]

Hi! I'd check out the videos on parameters in this playlist 56.6. and 56.7 kzbin.info/aero/PLNIs-AWhQzclbRVLCZlsFvpz6fz2nPGbt

[@deeg3317]

@@WiseOwlTutorials Thanks a lot. Your videos are extremely helpful.

[@DeenQuery]

Very beneficial

[@WiseOwlTutorials]

Thank you!

[@alejandroalvarez4705]

Thank you! Great stuff!

[@dennyba75mytd78]

Amazing!!! Thank you so much!!!

[@AmitSharma-po1zb]

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

[@WiseOwlTutorials]

Hi Amit, again, sorry but I don't have any experience with this - I'm confident that Google will have the answer!

[@AmitSharma-po1zb]

Hey Andrew...plz dont be sorry..actually this issue is solved though Google couldn't help in it as well.. 😀 thanks again for your extended help..your videos are amazing..r u planning anything on MS Access and ACCESS VBA as well

[@mapt3338]

I get the error Invalid Object Name 'dbo.Film' when I run it. I don't know what I did wrong. I can run the query in Microsoft SQL management Studio. still figuring it out. nice tutorial though

[@WiseOwlTutorials]

How strange! The only thing that I can think of is that the connection string is pointing to a different database. Please let me know if you figure it out!

[@rajeshmajumdar4999]

👍👍👍 Awesome

[@WiseOwlTutorials]

Thanks Rajesh!

[@dennyba75mytd78]

By the way, does anyone know how we can have the header?

[@dennyba75mytd78]

ops my apologize it's in the last section of the video

[@tejamarneni]

One quick question Andrew, are you using office 365 or office 2016?

[@WiseOwlTutorials]

Hi Ravi, we use Office 365, currently on version 1808.