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!
Nesta página do site você pode assistir ao vídeo on-line Connect to Microsoft SQL Server using VBA duração hora minuto segundo em boa qualidade , que foi baixado pelo usuário SimpleExcelVBA 29 Agosto 2021, compartilhe o link com seus amigos e conhecidos, no youtube este vídeo já foi visto 13,555 vezes e gostou 221 espectadores. Boa visualização!
