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!
На этой странице сайта вы можете посмотреть видео онлайн Connect to Microsoft SQL Server using VBA длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь SimpleExcelVBA 29 Август 2021, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 13,555 раз и оно понравилось 221 зрителям. Приятного просмотра!
