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

CODE FROM VIDEO: https://simpleexcelvba.com/howtocon...

WATCH NEXT:
○ How to install MS SQL Server:    • How to install Microsoft SQL Server a...  
○ Record macro in EXCEL:    • How to RECORD MACRO in Excel?  Simpl...  
○ Internet Explorer automation:    • How to create web automation using In...  

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:
○ Microphone https://amzn.to/3JidXEt
○ Keyboard https://amzn.to/3sAMckx
○ Mouse https://amzn.to/3euvwmn
○ Monitor https://amzn.to/3qoJITq

FREE TubeBuddy 30DAYS TRIAL:
○ https://www.tubebuddy.com/freetrial?a...

SITE & SOCIALS:
○ Website: https://simpleexcelvba.com/
○ Facebook:   / simpleexcelvba  
○ Pinterest:   / simpleexcelvba  
○ Buy me a coffee: https://www.buymeacoffee.com/SimpleEx...

CONTACT:
[email protected]

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!