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-con...
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 30-DAYS 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:
tomasz@simpleexcelvba.com
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!
Sur cette page du site, vous pouvez voir la vidéo en ligne Connect to Microsoft SQL Server using VBA durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur SimpleExcelVBA 29 août 2021, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 13,555 fois et il a aimé 221 téléspectateurs. Bon visionnage!
