Passing Parameter Values from Excel to SQL Server
29 هزار بار بازدید -
2 سال پیش
-
In this video we will
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!
★☆★ 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!
2 سال پیش
در تاریخ 1401/09/28 منتشر شده
است.
29,080
بـار بازدید شده