Connect to Microsoft SQL Server using VBA

Publicado el: 29 agosto 2021
en el canal de: SimpleExcelVBA
13,555
221

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!


En esta página del sitio puede ver el video en línea Connect to Microsoft SQL Server using VBA de Duración hora minuto segunda en buena calidad , que subió el usuario SimpleExcelVBA 29 agosto 2021, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 13,555 veces y le gustó 221 a los espectadores. Disfruta viendo!