HDTutorial
EN
How to Create Report in Seconds by Fetching Data from SQL Server using Excel VBA

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Create Report in Seconds by Fetching Data from SQL Server using Excel VBA

199,595 views November 7, 2016 11:34

Watch on YouTube
ChannelYoda Learning - Excel, Excel VBA and Power BI

Chapters

Description from the creator

In this video, I'm going to show you how to import a database from a SQL Server into Excel. This is a great way to get the data out of the database and into a spreadsheet for analysis.

👉 Join now our QnA Community - bit.ly/335Fic7

Frankly speaking, I faced this kind of situation in my previous company and I prepared the report using VBA and handed over the file to my manager.

Now, whenever he will click the button he will get the report of the LIVE DATA from SQL to Excel.

00:00 Introduction to SQL Server
00:45 How to Import Data from SQL Server to Excel
01:51 Press Excel Shortcuts Alt + F11 (To open a VBA Page)
02:38 How to insert Module in Excel VBA
02:45 How to write code in Excel VBA
07:47 How to run the code in SQL Server
08:14 How to a create button in Excel to get data from SQL Server
10:04 Text Formatting using Excel Macros

Import Data from SQL Server to Excel | Create a report in seconds
#Excel #SQL #ImportData

👉 Check out Excel VBA tutorial Playlist - youtube.com/playlist?list=PLnVcHd3TXd2oTUCsERbS…

Let's Connect:

👉 Follow us on Instagram instagram.com/yodalearning/
👉 Follow our boards at in.pinterest.com/yodalearning/pins/

About this tutorial

Yoda Learning - Excel, Excel VBA and Power BI published this 11:34 video tutorial on November 7, 2016. It has been watched 199,595 times on YouTube.

Category
Education
Duration
11:34
Published
November 7, 2016
Views
199,595
Likes
1,703

Tags

Share

This tutorial in other languages