Passing Parameter Values from Excel to SQL Server
In this video we will perform what should be a relatively simple task but isn't intuitive at all. I'll show you how to pass the values from Excel cells to a dynamic SQL Server query that will execute and return the values to Excel. This will make a nice little Excel data portfolio project for those of you looking to learn. Check it out! I will say there are many ways to do this, but this method is fine for personal use only, not for a distributable deliverable due to the lack of stored proc usage.
★☆★ Join this channel to get access to perks: ★☆★
/ @anthonysmoak
Watch the entire playlist to learn additional techniques using stored procedures:
• SQL Meets Excel: Advanced Data Retrieval
#SQL #analytics #tsql #excel #dataanalyst #data
Download the Database used in the video: https://learn.microsoft.com/en-us/sql...
★☆★ FOLLOW ME BELOW: ★☆★
Blog ► https://anthonysmoak.com/
Instagram ► / @anthonysmoakdata
Facebook ► / anthonybsmoak
Tableau Public ► https://bit.ly/3JMKsLY
1:48 Demonstrate worksheet
3:45 SQL Query Overview
4:45 Start worksheet Build
5:47 Record Macro
6:17 Connect to Data
8:17 Explain & Build VBA
16:06 Insert Button for Refresh
17:16 Impromptu Debugging
17:54 It Works!!
18:30 Adjust Column Width Property
19:24 Confirm Results
20:00 Date Picker Ad-In
20:48 Password Protect VBA
21:28 Wrap it Up B!
On this page of the site you can watch the video online Passing Parameter Values from Excel to SQL Server with a duration of hours minute second in good quality, which was uploaded by the user Anthony Smoak 01 January 1970, share the link with friends and acquaintances, this video has already been watched 44,509 times on youtube and it was liked by 651 viewers. Enjoy your viewing!
