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.

Watch the entire playlist to learn additional techniques using stored procedures:
https://youtube.com/playlist?list=PLRNrM8SIqgQZ4u5yGSlVNeGgej1lcwLwr&feature=shared

#SQL #analytics #tsql #excel #dataanalyst #data
Download the Database used in the video: https://learn.microsoft.com/en-us/sql/samples/wide-world-importers-dw-install-configure?view=sql-server-ver16

★☆★ FOLLOW ME BELOW: ★☆★
Blog ► https://anthonysmoak.com/
Instagram ► https://Instagram.com/@anthonysmoakdata
Facebook ► https://www.facebook.com/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!