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 ► Instagram: @anthonysmoakdata
Facebook ► 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!

• #people_blogs
• #excel
• #exceldashboard
• #parameters
• #sql
• #tsql
• #learn_sql
• #sql_course
• #sql_server
• #sql_tutorial