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!