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!
On this page of the site you can watch the video online Connect to Microsoft SQL Server using VBA with a duration of hours minute second in good quality, which was uploaded by the user SimpleExcelVBA 29 August 2021, share the link with friends and acquaintances, this video has already been watched 13,555 times on youtube and it was liked by 221 viewers. Enjoy your viewing!
