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

By Andrew Gould

[radheymaurya]

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

[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!

[KhalilYasser]

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

[sashatv]

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

[tejamarneni]

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

[turbo]

thank you very much for you and your team

[hubsun]

Thank you..great topic and explained well.

[cormackeenan]

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.

[tafa]

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

[douglasd]

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?

[deeg]

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

[noorsalh]

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?

[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.

[tejamarneni]

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

[mapt]

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

[AmitSharma-pozb]

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

[dennybamytd]

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