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.
CODE FROM VIDEO: https://simpleexcelvba.com/how-to-connect-to-microsoft-sql-server-using-vba/
WATCH NEXT:
○ Record macro in EXCEL: https://youtu.be/plKE2MQW8_E
○ Internet Explorer automation: https://youtu.be/gfdW_yLtidI
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 30-DAYS TRIAL:
○ https://www.tubebuddy.com/freetrial?a=SimpleExcelVBA
SITE & SOCIALS:
○ Website: https://simpleexcelvba.com/
○ Facebook: https://www.facebook.com/SimpleExcelVBA/
○ Pinterest: https://pinterest.com/simpleexcelvba/
○ Buy me a coffee: https://www.buymeacoffee.com/SimpleExcelVBA
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!
Comments are closed.