Connect to Microsoft SQL Server using VBA

In this video I’m going to show You how to connect to Microsoft SQL Server database using Excel VBA.

WATCH NEXT:

TIME STAMPS:
0:00 Intro
0:32 Adventure Works 2016 database
1:00 References
1:43 ADODB library & connection string
3:00 Provider for local database
3:38 SQL Query
4:13 Recordset
5:03 Summary
5:49 Leave a like & subscribe!

MY EQUIPMENT:

FREE TubeBuddy 30-DAYS TRIAL:

SITE & SOCIALS:

CONTACT:

Don't forget to leave like and subscribe to my channel, it means a lot to me :)

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel so I can continue to create and provide more content for You!

[theresahanvunguyen]

Thanks, really helpful! Amongst many videos, I found my answers here.

[turkaykoc]

Thank you very much for sharing valuable information.

[bassfischer]

Thank you! Interesting and informative content. Question.. You did not include any clean-up in your demo.. closing of connection, destroying objects, etc. Do you not consider that necessary?

[dislook]

Very nice, and we wish for lessons on linking excel VBA to sql server in addition, can I ask you a programming question, if you allow me

[johnharry]

hi. how to access database through network and to other PC's?
what is the connection string?

[rabihelhabta]

how can you get the table from sql with column name? and how you can reverse this process, i.e. a vba code that will update sql table from excel data? thank you

[rushabkumat]

I am getting an error in the second last line. How can I manage it. When I write sql query select* the code is working properly but when I write select distinct. I am getting an error in rssql.open sqlQuery, connection, adopenstatic

[kamalsardana]

Hey man!! Can you create the same video and i want to write my query in Excel.
Thanks in advance

[shankhapedia]

Can You reply a Code That can Retrieve Column Header from ADODB Recordset.
This Code Works Perfectly.
But, the Provider Name Change to 'MSOLEDBSQL'.
ASSUME ME AS BEGINNER.
THANK YOU FROM INDIA.